Re: Locking a database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jose Norberto" <nn_jose(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Locking a database
Date: 2001-04-30 19:08:56
Message-ID: 17876.988657736@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Jose Norberto" <nn_jose(at)hotmail(dot)com> writes:
> I want to make a pg_dump of a database, but I must be sure that no one is
> logged in.

Why?

pg_dump will return a consistent state of the database even if other
transactions are proceeding meanwhile.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Coers 2001-04-30 19:12:22 Re: Performance with Large Volumes of Data
Previous Message Michelle Murrain 2001-04-30 18:50:15 wierd problems with DBI/DBD::pg?