... - Mailing list pgsql-general

From Nikos Mouat
Subject ...
Date
Msg-id Pine.LNX.4.10.9910040825320.16183-100000@rapture.cyberflunk.com
Whole thread Raw
In response to pgaccess removed from 6.5.2?  (Palle Girgensohn <girgen@partitur.se>)
List pgsql-general
Hi,
   I'm trying to backup a database using pg_dump, but whenever I try I
get an error telling me I am really hosed. The template1 database works,
psql works fine, the database is live and working just peachy, but I can't
back it up.

nm

--

[nikm@db01 /tmp]# pg_dump -o  darwin > q
pg_dump: couldn't find the template1 database.  You are really hosed.
Giving up.
[nikm@db01 /tmp]# env | grep PG
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
[nikm@db01 /tmp]# psql template1
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.95.1]

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: template1

template1=> \d
Database    = template1
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | root             | abc                              | table    |
 | root             | abc_pkey                         | index    |
 +------------------+----------------------------------+----------+

template1=> \q
[nikm@db01 /tmp]#




pgsql-general by date:

Previous
From: Joe Devlin
Date:
Subject: [PHP3] mysql-unsubscribe@lists.mysql.com
Next
From: Floridashe@aol.com
Date:
Subject: Re: mysql-unsubscribe@lists.mysql.com...here is the solution