Re: 2 versions running & using pg_dumpall

[Ralph Smith <smithrn@xxxxxxxxxxxxxxxx>]

On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:

Ralph Smith <smithrn@xxxxxxxxxxxxxxxx> 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

==============================================

postgres=# \l

        List of databases

   Name    |  Owner   | Encoding 

-----------+----------+-----------

airburst  | root     | SQL_ASCII

postgres  | postgres | UTF8

template0 | postgres | UTF8

template1 | postgres | UTF8

(4 rows)

postgres=# select * from pg_database ;

  datname  | datdba | encoding | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | dattablespace | datconfig |               datacl               

-----------+--------+----------+---------------+--------------+--------------+---------------+--------------+---------------+-----------+-------------------------------------

postgres  |     10 |        6 | f             | t            |           -1 |         10818 |          524 |          1663 |           |

template1 |     10 |        6 | t             | t            |           -1 |         10818 |          524 |          1663 |           | {=c/postgres,postgres=CTc/postgres}

template0 |     10 |        6 | t             | f            |           -1 |         10818 |          524 |          1663 |           | {=c/postgres,postgres=CTc/postgres}

airburst  |  17032 |        0 | f             | t            |           -1 |         10818 |          524 |          1663 |           |

(4 rows)

From 7.4's postgresql.conf in /etc/postgresql/7.4/main:

#---------------------------------------------------------------------------

# CONNECTIONS AND AUTHENTICATION

#---------------------------------------------------------------------------

# - Connection Settings -

tcpip_socket = true

max_connections = 100

        # note: increasing max_connections costs about 500 bytes of shared

        # memory per connection slot, in addition to costs from shared_buffers

        # and max_locks_per_transaction.

#superuser_reserved_connections = 2

port = 5433

unix_socket_directory = '/var/run/postgresql'

#unix_socket_group = ''

#unix_socket_permissions = 0777 # octal

#virtual_host = ''              # what interface to listen on; defaults to any

From 8.2's postgresql.conf in /etc/postgresql/8.2/main:

#---------------------------------------------------------------------------

# CONNECTIONS AND AUTHENTICATION

#---------------------------------------------------------------------------

# - Connection Settings -

#listen_addresses = 'localhost'         # what IP address(es) to listen on;

                                        # comma-separated list of addresses;

                                        # defaults to 'localhost', '*' = all

                                        # (change requires restart)

port = 5432                             # (change requires restart)

I certainly can use some help!

Ralph Smith

smithrn@xxxxxxxxxxxxxxxx

=====================