Обсуждение: 2 versions running & using pg_dumpall

Ralph Smith <smithrn@u.washington.edu> writes:
> I want to use v8.2's pg_dumpall to export v7.4's data into a text file.

> prompt:/usr/lib/postgresql/8.2/bin$ ./pg_dumpall -c -v -p 5433 >
> myfile.txt

Works for me.  What does the -v give you on stderr?  Also,
7.4.what-exactly and 8.2.what-exactly?

            regards, tom lane

Ralph Smith <smithrn@u.washington.edu> writes:
> On Oct 25, 2007, at 10:13 AM, Tom Lane wrote:
>> Works for me.  What does the -v give you on stderr?  Also,
>> 7.4.what-exactly and 8.2.what-exactly?

> Sorry for the bulk here...

Hmph.  Nothing obviously wrong there, except that it's not finding
anything except template1.  What does "select * from pg_database"
show?

            regards, tom lane

Ralph Smith <smithrn@u.washington.edu> writes:
> On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:
>> Hmph.  Nothing obviously wrong there, except that it's not finding
>> anything except template1.  What does "select * from pg_database"
>> show?

> postgres=# select * from pg_database ;
>    datname  | datdba | encoding | datistemplate | datallowconn |
> datconnlimit | datlastsysoid | datfrozenxid | dattablespace |
> datconfig |               datacl
> -----------+--------+----------+---------------+--------------
> +--------------+---------------+--------------+---------------
> +-----------+-------------------------------------

Ummm ... those are the column headings for 8.2 pg_database, not 7.4.
You're looking at the wrong postmaster.

            regards, tom lane

Ralph Smith <smithrn@u.washington.edu> writes:
> On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:
>> Ummm ... those are the column headings for 8.2 pg_database, not 7.4.
>> You're looking at the wrong postmaster.

> postgres@smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql
> Welcome to psql 7.4.13, the PostgreSQL interactive terminal.

> Type:  \copyright for distribution terms
>         \h for help with SQL commands
>         \? for help on internal slash commands
>         \g or terminate with semicolon to execute query
>         \q to quit

> postgres=# select * from pg_database ;
>    datname  | datdba | encoding | datistemplate | datallowconn |
> datconnlimit | datlastsysoid | datfrozenxid | dattablespace |
> datconfig |               datacl

Still the wrong column headings :-(.  What you have above is a 7.4 psql
connecting to an 8.2 postmaster, no doubt because the default port
number wired into it is the 8.2 installation's not the 7.4 one's.
You'll need to explicitly give a -p switch to psql to connect to the
correct postmaster.

            regards, tom lane

On Oct 25, 2007, at 1:57 PM, Tom Lane wrote:

> Ralph Smith <smithrn@u.washington.edu> writes:
>> On Oct 25, 2007, at 1:09 PM, Tom Lane wrote:
>>> Ummm ... those are the column headings for 8.2 pg_database, not 7.4.
>>> You're looking at the wrong postmaster.
>
>> postgres@smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql
>> Welcome to psql 7.4.13, the PostgreSQL interactive terminal.
>
>> Type:  \copyright for distribution terms
>>         \h for help with SQL commands
>>         \? for help on internal slash commands
>>         \g or terminate with semicolon to execute query
>>         \q to quit
>
>> postgres=# select * from pg_database ;
>>    datname  | datdba | encoding | datistemplate | datallowconn |
>> datconnlimit | datlastsysoid | datfrozenxid | dattablespace |
>> datconfig |               datacl
>
> Still the wrong column headings :-(.  What you have above is a 7.4
> psql
> connecting to an 8.2 postmaster, no doubt because the default port
> number wired into it is the 8.2 installation's not the 7.4 one's.
> You'll need to explicitly give a -p switch to psql to connect to the
> correct postmaster.
>
>             regards, tom lane
===========================================
postgres@smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433
psql: FATAL:  database "postgres" does not exist

looks like I have to re-install PG 7.4.  There's only only 41 MB there.

On Ubuntu, what are my options?
Use Synaptic to uninstall?

Once that's done, any caveats WRT the subsequent install?

All this is so I can practice and make mistakes here on test boxes
before w move the real on from 7.4 to 8.2.

Thanks a bunch Tom.

Ralph Smith
smithrn@u.washington.edu
=====================

Hi,

On Thu, 2007-10-25 at 15:36 -0700, Ralph Smith wrote:
> postgres@smithrn-ltb1:/usr/lib/postgresql/7.4/bin$ ./psql -p 5433
> psql: FATAL:  database "postgres" does not exist

7.4 does not have postgres database. use ./psql template1 -p 5433.

--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/