System: install postgresql database server 2008 r2 server version 9.2
Failure phenomenon is landing in local server with pgadmin tool database connection fails, and it will cause the server to run this tool works on automatic restart after
Server is running normally after close the tool, because has just come into contact with the postgresql database, are with built-in tools backup database file types are. Backup file
This tool can't use now is on the server backup under the command line: pg_dump -h localhost -u postgres databasename & gt; C: \ databasename bak
Recently found so after backup file is becoming more and more small, before use the pgadmin tool backup file is bigger and bigger? Is this normal?
Still have even if postgresql database on the server 2008 how to check the database is running now? Whether is to look at the inside of the database service start?
Server 2008 after restarting the database is normal boot?
Pray god to solve!!!!!!!!!!

CodePudding user response:

1. Is to see whether the database service start service?
-- -- -- -- -- -- -- -- -- yes, set to automatic, the database will be along with the computer start automatically start

2. After the backup file is more and more small
-- -- -- -- -- -- -- - you open the file, it is a SQL statement. Maybe your project have a delete action, so it is possible to file smaller.

CodePudding user response:

I am new to the postgresql database, look at the SQL statement in the file? I myself thank you!!!!!!

CodePudding user response:

C: \ databasename bak
You is not only a postgresql, novice or computer novices. Guess guess