Re: Moving from Mysql

On Sat, May 22, 2010 at 11:06:02PM -0400, Stephen Frost wrote:
> * 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)

The way to call pg_dump so it goes to the most flexible format in
pg_dump -Fc. You can find out more about this format in the man page,
if you're using a unix-like system, or in the on-line docs:

http://www.postgresql.org/docs/current/static/app-pgdump.html

> > mysql mydata_base_name < script.sql
>
> psql

With the output of pg_dump -Fc, you'll be using pg_restore, which is
more complex, but much more flexible.

http://www.postgresql.org/docs/current/static/app-pgrestore.html

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

Here are a few more specific ones, some of which may apply to your
situation:

http://sql-info.de/mysql/gotchas.html
http://www.raditha.com/mysql/mysql2pgsql.php
http://www.in-nomine.org/~asmodai/mysql-to-pgsql.html
http://blog.gtuhl.com/2010/04/15/not-a-fan-of-mysql/
http://pgfoundry.org/projects/mysql2pgsql/
http://search.cpan.org/search?query=SQL%3A%3ATranslator&mode=all
http://www.metatrontech.com/wpapers/mysql2postgresql.pdf
http://www.data-conversions.net/products.php?prod_num=5&&dest=MENU&&ID=200
http://pgfoundry.org/projects/mysqlcompat

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

Also check out host-based authentication, which you control with an
external file called pg_hba.conf:

http://www.postgresql.org/docs/current/static/client-authentication.html

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate