- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Archived Discussions
Effective March 31st, we will no longer engage on PostgresRocks.
How to engage with us further?
- Thought Leadership: EDB Blogs
- Tips and Tricks: Postgres Tutorials
- Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket
- Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
There were the steps i have been doing however when i click the download button, nothing happens.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
Hi Matt,
We are looking into this.
Meanwhile can you please share the httpd logs for PEM.
--
Regards
Ajinkya Bangale
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
which logs would you like
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
i have tried this, it will not allow me to save my query results, only if i get an error.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
Hi MattGorham,
We will check and let you know.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Pem query results to csv
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content