From: | Mike Mascari <mascarim(at)yahoo(dot)com> |
---|---|
To: | Nikos Mouat <nikm(at)cyberflunk(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] You are really hosed. |
Date: | 1999-10-06 07:23:37 |
Message-ID: | 19991006072337.5259.rocketmail@web2102.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
--- Nikos Mouat <nikm(at)cyberflunk(dot)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(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]#
>
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(at)yahoo(dot)com)
=====
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Widenius | 1999-10-06 10:26:43 | Re: PostgreSQL vs Mysql comparison |
Previous Message | Mike Mascari | 1999-10-06 07:18:31 | Re: [GENERAL] Yet another btree gotcha |