Pem query results to csv

[MattGorham]

is it possible to download query results to a remote server with pem,  CAn you download the query results from a postgres server registered in pem to your pem server c drive for example.

matt

[slonkar]

Hi Matt,

You can download the query results in CSV file of the servers registered from the PEM dashboard.

Below are the steps :

1) Connect to the database server you want to execute query on the PEM dashboard.

2) select database under that server

3) Click on Menu Tools -> Query Tool

4) Type the query you want to execute and click thunderbolt icon (Execute/Refersh/) button, it will display the output on the ‘Data Output’ section below it.

5) Then click on the download button (Download as cvs F8)

The query result will get downloaded on the server where you have opened the PEM dashboard in the browser.

Please refer the attached screenshot for it and let us know in case of any issues/queries.

Regards,

Sudhir 

[MattGorham]

There were the steps i have been doing however when i click the download button,  nothing happens. 

[ajinkya]

Hi Matt,

We are looking into this.

Meanwhile can you please share the httpd logs for PEM.

--

Regards 

Ajinkya Bangale

[MattGorham]

which logs would you like

[slonkar]

Hi @MattGorham,

Could you please verify that your browser is not blocking the download pop-ups.

Also, could you please update us on the below points :

1) PEM server version 

2) screenshot of the steps followed by you.

Regards,

Sudhir

[MattGorham]

Pem version is 7,

the download is not being blocked.  If i run a query and it out puts an error,  it will allow me to download the csv.  

say for example,  select * frm table, see below.  But if i run a query that returns results it doesnt do  anything when i click the csv button

[MattGorham]

i checked the error log when and found this when i generated the error for the screen shot in my previous post.  I did not get an entry when i attempted to download csv with a query that had results.

]
[Thu Nov 29 13:02:26.925940 2018] [wsgi:error] [pid 76262:tid 139983490201344] 2018-11-29 13:02:26,925: ERROR\tpgadmin:\tfailed to execute query ((with server cursor) for the server #2$
[Thu Nov 29 13:02:26.925961 2018] [wsgi:error] [pid 76262:tid 139983490201344] error message:ERROR: syntax error at or near "frm"
[Thu Nov 29 13:02:26.925964 2018] [wsgi:error] [pid 76262:tid 139983490201344] LINE 1: ...SOR:CONN:8112481" CURSOR WITHOUT HOLD FOR select * frm table

[Ranjan]

Hi MattGorham,

We have attached screenshots to download result in CSV format. Please go throgh it. If query results in successful output then result set can get download or if produces error, that is also downloadable.

Kindly refer attachement. 

[MattGorham]

i have tried this,  it will not allow me to save my query results,  only if i get an error.

[Ranjan]

Hi  MattGorham,

We will check and let you know.

[Ranjan]

We found this as known bug in PEM earlier to 7.3, it has been in PEM version 7.3 and onwords. 

Please try by upgrading PEM version.

[MattGorham]

Is it possible to do an in place upgrade from 7.0 to 7.3

[slonkar · Accepted solution]

Hi @MattGorham,

PEM database server is restarted during PEM server upgrade, and that would require a downtime. Below are the high-level steps:

1) Upgrade the remote PEM agents first

2) Upgrade PEM server (using pem-server installer, Database option)

3) Upgrade Apache ( using pem-server installer, Web services option)

We also recommend you to upgrade to the latest version of PEM server which 7.5 as it has more new and exciting features.

Please refer below documentation for the details

https://www.enterprisedb.com/docs/en/7.5/PEM_Upgrade_Migration_v7.5/toc.html

Please let us know in case of any issues/queries.

Regards,
Sudhir

[MattGorham]

Thanks for the info, I will have a look tomorrow