Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

2008-03-25 Thread Tri Quach
: pgsql-general@postgresql.org Subject: Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6 On 25/03/2008, Tri Quach [EMAIL PROTECTED] 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

Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

2008-03-25 Thread Andrej Ricnik-Bay
On 26/03/2008, Tri Quach [EMAIL PROTECTED] wrote: Hi Andrej, Hi Tri! 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? Not a syntax-problem; to use pg_dumpall you need to be the postgres (superuser). su - postgres pg_dumpall

[GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

2008-03-24 Thread Tri Quach
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? Thank you for your help. Tri

Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

2008-03-24 Thread Andrej Ricnik-Bay
On 25/03/2008, Tri Quach [EMAIL PROTECTED] 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