PostgreSQL recovery -- advice

My Windows server can not enter the system, I use PE to get the PostgreSQL installation files (including inside the data folder) copy out, would it be possible to restore the copied data to another computer's Postgresql database.?

Started by dream at May 12, 2016 - 4:18 PM

Can, be behind options with -D is the database directory in the startup items

Posted by Webster at May 20, 2016 - 4:42 PM

Novice, really do not understand, can say the details a bit more? First thank you!

Posted by dream at May 24, 2016 - 5:03 PM

I tried, not only is windows, then FreeBSD, copy the PgSQL directory. Then, re install FreeBSD, then install PgSQL, then PgSQL to replace the original copy of the past, even service started successfully. Restore the original old.
Methods 2 floor is a good method. As long as the data directory intact.

Note: to re install the PgSQL version of the note ah ah, and on the original server agreement.

Posted by Osmond at June 07, 2016 - 5:51 PM

It is better to guide out with PG_DUMP, and recovery.

Direct copy, and then re install the system, and then directly covering the recovery, there may be a problem.
Because the new OID and not the same as the original, that can lead to data loss,

Posted by Omar at June 18, 2016 - 6:29 PM

I have tried, service to start, but not through the pgadminIII connection, prompt:
Server doesn't listen
The server doesn't accept connections: the connection library reports
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?

While the service he stopped, no log. What is the reason for ah? Version is identical.

Posted by Dick at June 29, 2016 - 6:44 PM

If your service is started, try using PSQL tools, and see if you can really connect to a database.
If you want to use pgadminIII, whether in the machine, or connected to other machines, the first telnet IP address 5432, if appear blank, indicates that the service is started, but also to allow the host to access, which can be connected to the success.
Otherwise, check your postgresql.conf and hba.conf configuration files, set parameters.

Posted by Osmond at July 07, 2016 - 7:11 PM