BUG #6114: Bad path

Lists: pgsql-bugs
From: "Wiesiek" <wuwak(at)wp(dot)pl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6114: Bad path
Date: 2011-07-12 10:52:42
Message-ID: 201107121052.p6CAqgnS040843@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6114
Logged by: Wiesiek
Email address: wuwak(at)wp(dot)pl
PostgreSQL version: PG ADMIN 1.12.2
Operating system: Win2k3, Win2k8
Description: Bad path
Details:

When I try to backup i have a problem.
\"alfaCC2\"
I have to do the backup manually from the console and correct entry. This
problem occurs for me on several servers. Where can improve the path
correctly defined the?

########## LOG ###############
D:\Program Files\PostgreSQL\9.0\bin\pg_dump.exe --host localhost --port 5432
--username "nova" --format custom --blobs --verbose --file
"J:\2011-07-12\alfaCC2.backup" \"alfaCC2\"
pg_dump: [archiver (db)] connection to database ""alfaCC2"" failed: FATAL:
database ""alfaCC2"" does not exist
pg_dump: *** aborted because of error

Process returned exit code 1.


From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>,"Wiesiek" <wuwak(at)wp(dot)pl>
Subject: Re: BUG #6114: Bad path
Date: 2011-07-12 14:57:00
Message-ID: 4E1C1A6C020000250003F230@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

"Wiesiek" <wuwak(at)wp(dot)pl> wrote:

> Description: Bad path

> When I try to backup i have a problem.
> \"alfaCC2\"

> I have to do the backup manually from the console and correct
> entry.

"Manually from the console" as opposed to what?

What "entry" do you correct? In what way?

> Where can improve the path correctly defined the?
>
> ########## LOG ###############
> D:\Program Files\PostgreSQL\9.0\bin\pg_dump.exe --host localhost
> --port 5432 --username "nova" --format custom --blobs --verbose
> --file "J:\2011-07-12\alfaCC2.backup" \"alfaCC2\"
> pg_dump: [archiver (db)] connection to database ""alfaCC2""
> failed: FATAL: database ""alfaCC2"" does not exist
> pg_dump: *** aborted because of error
>
> Process returned exit code 1.

You don't show any error message which mentions "path" in any way.
Why do you use that word to describe your problem?

One thing I do notice is that you didn't specify a database name on
the command line. What is your PGDATABASE environment variable
value? Maybe you just need to add the database name to the end of
your command line?

-Kevin