Hi,
Does anybody know what's the meaning of the c (lowercase) privilege in
PostgreSQL 8.2 Beta?
bd_test=# SELECT datacl FROM pg_catalog.pg_database WHERE datname='bd_test';
datacl
--
{=CTc/user1,user1=CTc/user1}
Hi,
In some *nix distributions the username 'postgres' is already in
/etc/passwd. If so, you don't need to create it again. Just assure that the
directory where the database cluster will reside belongs to the user
'postgres', and also when you'll go to create the DB cluster (with the command
Basing on the way you did the pg_dump (without the -C option), I think you
should have created the database before you performed the pg_restore,
You can see some examples of database backup/restore in this page:
http://nediam.com.mx/en/tips/backups_pgsql.php
Regards,
Javier
On Mon, 6
