1) try using crypt instead of trust in the pg_hba.conf file. I am not
sure of the details nor how this works, but this is worth trying.
2) Mirroring is not available. Your only choice is to run pg_dump,
copy if dump file to the remove machine, and recreate the database on the
remote machine.
-----Original Message-----
From: [EMAIL PROTECTED]
[SMTP:[EMAIL PROTECTED]]
Sent: Friday, May 14, 1999 11:54 AM
To: [EMAIL PROTECTED]
Subject: [ADMIN] Security and Backup Questions - New Trying
Dear friends :
I'm working with PostgreSQL for about 2 month and half. I've
been
searching in the mail lists in order to find information about two
critical doubts, without success. Here they're :
PS : ( I've installed PostgreSQL 6.4.2 under Linux Red-Hat 5.2 )
( I've got a RPM to install it. )
1) - PostgreSQL creates a file that is well-known : "pg_pwd". The
trouble
is this file, which contains the passwords of all users, is
perfectly
readable for any user in the linux-system. Is there a way to hide
the
password information from other normal users? I know that you can
create
users with crypted passwords manually. But I would like to hide even
the
crypted passwords from other users, like shadow in Linux.
2) - I would like to backup a database in another machine. The
User's
Guide tells about the "pg_dump" application, which dumps the
database
contents into a text file. But I would like more than this : to do a
mirror of the database, with something that could synchronize the
two
databases once a day( for example ), updating only the changed and
added records in the period. Is there a way to do this?
Sorry for my poor English. I need more practice in writing...
Really thanks in advance !!!
