Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting
Mailing Lists: postgresql.org > pgsql-general > 07 > 106534.html (Request Expert postgresql.org Support)

Re: [GENERAL] 2 versions running & using pg_dumpall

From: Ralph Smith <smithrn(at)u.washington.edu>
Date: Thu Oct 25 2007 - 15:48:16 EDT


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

> 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

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 -

Do you need help?X

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!

Do you need more help?X

Ralph Smith
smithrn@u.washington.edu

Received on Thu Oct 25 15:52:15 2007

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 18:53:37 EDT

Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library