postgres : 7.4.5
I need to restore my back up database with production data.
the steps i follow on backup database are:-
3) psql or pg_restore to import data into the backup database.
Am i doing the correct steps?.
If some clients are connected to the backup database during the 1st
the postmaster throws an error saying clients connected cannot drop database.
Any solution to the above problem would be great...
On Mon, 21 Feb 2005 19:51:10 +0530, Gourish Singbal <gourish(at)gmail(dot)com> wrote:
> This Error message was given when i was dropping the database.
> There are idle connections to the database as seen from ps -ef | grep postgres
> How can i drop the database with out restarting the postgres server.?.
> FYI: i am dropping the database to perform restoration of this backup
> database using psql from production.
> Gourish Singbal
In response to
pgsql-admin by date
|Next:||From: Sander Steffann||Date: 2005-02-23 08:01:41|
|Subject: Re: 64 bit rpms for 7.4.7??|
|Previous:||From: Tom Lane||Date: 2005-02-23 05:05:20|
|Subject: Re: 7.4.5 file write issue |