On Sat, May 22, 2010 at 11:06:02PM -0400, Stephen Frost wrote: > * 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) 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@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
