From: | Felipe Gasper <felipe(at)felipegasper(dot)com> |
---|---|
To: | David Gould <daveg(at)sonic(dot)net> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | pg_restore WAS Re: BUG #13702: pg_dump interprets “=” in a db name incorrectly |
Date: | 2015-10-23 18:20:38 |
Message-ID: | 562A7A76.9000700@felipegasper.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Apparently 9.0 can’t pg_restore DBs that have equals signs in them...at
least, such is the case with pg_restore on 9.0.18. It gets confused by
the “=”, even when it’s in the --dbname argument.
To me, that seems like a bug, as there’s no reason that the --dbname
argument should be interpreted as anything other than the name of a
database.
Does anyone here happen to know when pg_restore offered alternative ways
of specifying the database?
-FG
On 23 Oct 2015 7:45 AM, David Gould wrote:
> On Thu, 22 Oct 2015 20:30:20 -0500
> Felipe Gasper <felipe(at)felipegasper(dot)com> wrote:
>
>> Interesting -- also, in 9.0 I *can* do:
>>
>> dbname='...'
>>
>> … and it works. Undocumented, apparently (?), but it does the job.
>>
>> But, I actually have to support all the way back to 8.1, and I’m a bit
>> leery of relying on undocumented (?) features for our backup
>> functionality. Hopefully down the road we can just move everything to
>> >=9.3, and peace and love will reign. :)
>
> You can dump and load older version database from newer version clients.
> The dbname parsing problem you are having is on the client, not the server,
> so if you can arrange to take the backup with a more current client then
> one of the suggestions in this thread will work for you.
>
> -dg
>
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2015-10-23 18:33:04 | Re: pg_restore WAS Re: [BUGS] BUG #13702: pg_dump interprets “=” in a db name incorrectly |
Previous Message | Sergey Burladyan | 2015-10-23 14:36:15 | Re: BUG #13657: Some kind of undetected deadlock between query and "startup process" on replica. |