From: | "Sree Narayana" <sreeman007(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Problem in offline backup & restore |
Date: | 2006-09-05 14:03:50 |
Message-ID: | 8ea4d8d0609050703y66eaa3a8k510138639104dad2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi
I am trying to implement backup and restore feature.
For backup I am issuing the command from windows cmd prompt:
C:\ [path to pg_dump.exe ]\pg_dump.exe -i -h localhost -p 5432 -U postgres
-F c -b -v -f C:\MyBackups\db_backup.backup mydb
For restore I am issuing the following command:
C:\[path to pg_restore.exe ]\pg_restore.exe -i -h localhost -p 5432 -U
postgres -d mydb -c -v C:\MyBackups\db_backup.backup
The above 2 commands working perfect while database is online (running).
However the problem is they are not working while database is offline
(database shutdown)
It is showing the following error message:
pg_dump: [archiver (db)] connection to database "mydb" failed: could not
connect
to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" and accepting
TCP/IP connections on port 5432?
pg_dump: *** aborted because of error
Is it possible to backup & restore the database offline? If so what is the
problem in my command.
Please help me.
Thanks
Sreeman
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2006-09-05 14:24:26 | Re: Problem in offline backup & restore |
Previous Message | Sean Davis | 2006-09-04 23:16:59 | Re: windows+pgsql |