* Luis Daniel Lucio Quiroz (luis.daniel.lucio@xxxxxxxxx) wrote: > 1. whar are equivalent for these commands: > in mysql: mysqldump mydata_base_name pg_dump (pg_restore to restore from the dump, if you use a non-SQL format for it, which can give you the ability to do a parallel-restore) > mysql mydata_base_name < script.sql psql > 2. any link to read about how to admin pgsql with mysql backgraounds, The PG documentation is really quite good: http://www.postgresql.org/docs/8.4/ > 3. how users are managed in pgsql, i need to create a specifiq username for db, > but how? PG Roles (users and groups) are managed on a per-cluster level. There isn't a really good way to do them at a per-database level today. A cluster in PG is a full PG instance and a single cluster contains multiple databases. You can manage which databases users are allowed to connect to though, check out the GRANT command. Thanks, Stephen
Attachment:
signature.asc
Description: Digital signature
