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 !!!
