Re: Need help to migrate pqSQL db 8.0.3 to 8.2.6

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

On 25/03/2008, Tri Quach <tquach(at)k12(dot)hi(dot)us> 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

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(at)lyris2 backups]# ls
[root(at)lyris2 backups]# pg_dumpall > dbfile
pg_dumpall: could not connect to database "template1": FATAL: role "root"
does not exist

[root(at)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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Andrej Ricnik-Bay
Sent: Monday, March 24, 2008 3:58 PM
To: Tri Quach
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Need help to migrate pqSQL db 8.0.3 to 8.2.6

On 25/03/2008, Tri Quach <tquach(at)k12(dot)hi(dot)us> 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(at)postgresql(dot)org)
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(at)k12(dot)hi(dot)us 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
______________________________________________________________________

On 26/03/2008, Tri Quach <tquach(at)k12(dot)hi(dot)us> 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 > dbfile

If you'd rather run it individually for each DB become the
user who owns the respective DB.

> 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