Hi Andrej, I am running on Linux, Red Hat 3. I have hard time to use pg_dump command. Can you give me the syntax of pgdump? This is the error I got. [root@lyris2 backups]# ls [root@lyris2 backups]# pg_dumpall > dbfile pg_dumpall: could not connect to database "template1": FATAL: role "root" does not exist [root@lyris3 backups]# PGUSER=nssb pg_dumpall > dbfile pg_dumpall: query failed: ERROR: permission denied for relation pg_authid pg_dumpall: query was: SELECT rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcatupdate, rolcanlogin, rolconnlimit, rolpassword, rolvaliduntil, pg_catalog.shobj_description(oid, 'pg_authid') as rolcomment FROM pg_authid ORDER BY 1 Thank you for your help. Tri. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Andrej Ricnik-Bay Sent: Monday, March 24, 2008 3:58 PM To: Tri Quach Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Need help to migrate pqSQL db 8.0.3 to 8.2.6 On 25/03/2008, Tri Quach <tquach@xxxxxxxxx> wrote: > Hi All, > I installed pqsql 8.2.6 on a new server. I need to migrate the data from > pqSQL db 8.0.3 on the old server to 8.2.6 on the new server. Can anyone > provide me a document how to migrate? It's part of the package. Read the INSTALL document that comes with postgres, it has an UPGRADE section. In a nutshell you want to use pg_dump (or pg_dumpall, depending on how many databases you have loaded) ... you can either save the files, install the new version and import them, or you can (if you start the newer version on a different port than 5432 and have it use a different base directory) have both versions running at the same time. What OS & version are you running PG on? And if you can, use 8.2.7 > Thank you for your help. > > Tri Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general ______________________________________________________________________ This email was scanned by the MessageLabs Security System contracted by the Hawaii Dept Of Education. If you receive suspicious/phish email, forward a copy to spamreport@xxxxxxxxx This helps us monitor suspicious/phish email getting thru. You will not receive a response from us, but rest assured the information received will help to build additional protection. For info about this service please visit http://www.messagelabs.com/email ______________________________________________________________________ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
