Online Documentation for Data Export for PostgreSQL
EMS Data Export FAQ
Please read this page attentively if you have questions about Data Export for PostgreSQL.
- What is EMS Data Export for PostgreSQL?
- What do I need to start working with EMS Data Export for PostgreSQL?
- What is the difference between the Export feature of SQL Manager for PostgreSQL and the Data Export for PostgreSQL standalone utility?
- Are there any limitations implied in the trial version as compared with the full one?
- What is the easiest way to configure the template files for the Data Export console application?
- I work behind a firewall (router). Can EMS Data Export connect to a remote PostgreSQL server?
- Why cannot I connect to PostgreSQL Server?
A: EMS Data Export for PostgreSQL is a powerful program to export your data quickly from PostgreSQL databases to any of 20 available formats, including MS Access, MS Excel, MS Word (RTF), HTML, XML, PDF, TXT, CSV, DBF and others. Data Export for PostgreSQL includes a wizard which allows you to set export options for each table visually (destination file name, exported fields, data formats, and much more) and a command-line utility to export data from tables and queries in one-touch.
A: First of all, you must have a possibility to connect to some local or remote PostgreSQL server to work with Data Export. You can download PostgreSQL database server from http://www.postgresql.org/download/. Besides, you need your workstation to satisfy the system requirements for Data Export for PostgreSQL.
A: First of all, Data Export for PostgreSQL works faster as it is a considerably lighter application. Besides, it provides additional features for query building, namely:
- export data from several tables simultaneously;
- export data from tables and queries selected from different databases;
- the command-line version of the utility to export data using the configuration (template) file with all export settings.
A: Actually the trial version of the utility only allows you to export 20% of records at a time. In spite of this limitation, you can test all the features implemented in Data Export for PostgreSQL within the 30-day trial period.
A: You can configure the template files for each table visually using the Data Export Wizard application. Set the required export options and select the Tools | Save Template menu item on Step 8 or Step 9 of the wizard. All the options will be saved to the template file which can be used by the console application.
A: If due to the security policy accepted in your corporate network or by your host provider you cannot connect to your PostgreSQL server directly through TCP/IP (for example a firewall prevents this), you can use SSH or HTTP tunneling feature of SQL Manager to fulfill your task.
Q: Why cannot I connect to PostgreSQL Server?
A: 1. Make sure that there is a record for your client PC in pg_hba.conf file on PostgreSQL server. This file can be found in database cluster's data directory.
2. If you connect to the remote server, then the TCP/IP connections should be allowed on the remote server. In this case you need to edit file postgresql.conf on the server: just add the name or TCP/IP of the client PC in the listen_addresses list. Or you can as well put * character; in this case the connection from any host will be allowed. You can get the same result if you run the server with -i option, which is the same as listen_addresses = '*'.
3. Make sure that you enter the correct login/password.
4. You use password authentication, but it is not supported in Data Export.
If you still have any questions, contact us at Support Center.