Re: Locking a database - Mailing list pgsql-general

From Tom Lane
Subject Re: Locking a database
Date
Msg-id 17876.988657736@sss.pgh.pa.us
Whole thread Raw
In response to Locking a database  ("Jose Norberto" <nn_jose@hotmail.com>)
Responses Re: Locking a database
List pgsql-general
"Jose Norberto" <nn_jose@hotmail.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

pgsql-general by date:

Previous
From: "Fred Ingham"
Date:
Subject: RE: PostgreSQL and mySQL database size question
Next
From: John Coers
Date:
Subject: Re: Performance with Large Volumes of Data