From: | Nikos Mouat <nikm(at)cyberflunk(dot)com> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | You are really hosed. |
Date: | 1999-10-06 05:38:11 |
Message-ID: | Pine.LNX.4.10.9910052237410.24477-100000@rapture.cyberflunk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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. What does this mean? Why doesn't it want to work??
nm
--
[nikm(at)db01 /tmp]# pg_dump -o darwin > q
pg_dump: couldn't find the template1 database. You are really hosed.
Giving up.
[nikm(at)db01 /tmp]# env | grep PG
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
[nikm(at)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(at)db01 /tmp]#
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 1999-10-06 06:02:51 | Re: [GENERAL] copying from one table to another |
Previous Message | Gene Selkov, Jr. | 1999-10-06 05:33:20 | Yet another btree gotcha |