* Luis Daniel Lucio Quiroz (luis.daniel.lucio@gmail.com) 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