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_dum

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

2008-03-25 Thread Tri Quach
ch 24, 2008 3:58 PM To: Tri Quach Cc: 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 > p

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

[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