Re: Moving from Mysql

* Luis Daniel Lucio Quiroz (luis(dot)daniel(dot)lucio(at)gmail(dot)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