--- Nikos Mouat <nikm@cyberflunk.com> wrote:
>
> 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@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]#
>
You show yourself attempting to dump a database
called "darwin", while connecting to and displaying
tables in the "template1" database. If the data you
wish to dump is in template1, you should issue the
command:
pg_dump -o template1 > q
Hope that helps,
Mike Mascari
(mascarim@yahoo.com)
=====
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com