From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: 2 versions running & using pg_dumpall |
Date: | 2007-10-25 19:48:16 |
Message-ID: | EC9804FD-C2A1-4D36-A5E1-F77D50305AD2@u.washington.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Oct 25, 2007, at 12:24 PM, Tom Lane wrote:
> Ralph Smith <smithrn(at)u(dot)washington(dot)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
==============================================
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(at)u(dot)washington(dot)edu
=====================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-25 20:09:28 | Re: 2 versions running & using pg_dumpall |
Previous Message | Johnson Jesse | 2007-10-25 19:45:02 | PostgreSQL .msi Installation Failure |