The Postgresql I use is configured to authenticate users via md5
(trust option in pg_hba.conf file)
These days, after pg_dump'ing a database, and then reimporting it,
Postgresql asks for the password of every user which is described
by the \connect command in the script. I have used the
Hi,
According to some answers about the consistency of
a database in a snapshot of a whole
HD (excluding proc, tmp, and dev, of
course)and without stopping the postmaster service,
it is said it should work because it's like
if the system has
crashed, so restoring files from
the HD and
Hi
Here, where I work, the backups of the postgresql
databases are being done the following way:
There is a daily copy of nearly all the hd
(excluding /tmp, /proc, /dev and so on) in which databases are
and besides this there is also one script which makes the pg_dump of each one of the