Peter,
>From what I understand (and I'm still fairly new to Postgres) you won't get
a perfect copy while Postmaster is running, but there is a way to backup the
entire database while it's running: pg_dumpall.
pg_dumpall by default is in the /usr/bin directory, and they usage is
simple: /usr/bin/
Hello,
How do people normally backup up postgresql databases? The obviously safe
solution is to shut down the database during backup, but is Postgresql
storage such that it's safe to backup a running DB? I.e., is the database
guaranteed to be in a consistent state after restoration?
I'm talking
On Saturday, March, 2001-03-17 at 00:13:37, Bruce Momjian wrote:
>
> If you are running PostgreSQL 7.1 or earlier, the 'query' button will
> not work unless you compile PostgreSQL with debug symbols (-g), or apply
> the supplied patch 'query_display.diff' and recompile PostgreSQL. The
> later me
