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

Search Discussions

  • Andrej Ricnik-Bay at Mar 25, 2008 at 1:57 am

    On 25/03/2008, Tri Quach 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
  • Tri Quach at Mar 25, 2008 at 8:13 pm
    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@postgresql.org
    On Behalf Of Andrej Ricnik-Bay
    Sent: Monday, March 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 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@postgresql.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@k12.hi.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
    ______________________________________________________________________
  • Andrej Ricnik-Bay at Mar 25, 2008 at 8:28 pm

    On 26/03/2008, Tri Quach 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedMar 25, '08 at 1:39a
activeMar 25, '08 at 8:28p
posts4
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Tri Quach: 2 posts Andrej Ricnik-Bay: 2 posts

People

Translate

site design / logo © 2022 Grokbase