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 envir
Hi,
I was trying to create cluster-wide functions but without success.
Even creating one function in template1 did not work. If I create
a new database it is copied from template1 to new databases,
but older databases don't have that created function.
Is it possible to do something like that in pos
Hi,
I'm using postgresql 7.2. While issuing the CLUSTER command on a table,
I got some notices telling me "drop would implicitly delete ...".
After the CLUSTER command, the table was like if was created again,
and the grants were not preserved.
The postgresql sql reference says "CLUSTER preserves
this work well? I know there are other
procedures and I would be pleased to know that
this procedure works fine.
Thanks in advance,
Enio
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
da
