Re: [GENERAL] You are really hosed.

--- 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