Thread: uppercase database name in backup & restore in pgagmin 1.12.2 windows give errors
uppercase database name in backup & restore in pgagmin 1.12.2 windows give errors
From
Doug Easterbrook
Date:
hi there:
Doug Easterbrook
I know this is for bug reports, so I'll report the one I've run into on windows. I haven't tried OSX as I normally do command line to backup and restore databases.
platform: windows
pgdmin version 1.12.2
the issue:
if the database name that you create is in mixed case and you try to restore it using right-click restore, the command in the pgadmin window will escape the database name but pg_Restore will not restore it.
If I change the database name to be all lower case and restore, it works (and then I can change it to upper case).
Doug Easterbrook
Arts Management Systems Ltd.
Phone (403) 536-1205 Fax (403) 536-1210
Re: uppercase database name in backup & restore in pgagmin 1.12.2 windows give errors
From
Guillaume Lelarge
Date:
Le 09/01/2011 18:13, Doug Easterbrook a écrit : > hi there: > > I know this is for bug reports, so I'll report the one I've run into on windows. I haven't tried OSX as I normally docommand line to backup and restore databases. > > platform: windows > > pgdmin version 1.12.2 > > the issue: > > if the database name that you create is in mixed case and you try to restore it using right-click restore, the commandin the pgadmin window will escape the database name but pg_Restore will not restore it. > > If I change the database name to be all lower case and restore, it works (and then I can change it to upper case). > Yes, we are aware of this issue. I'm working on this. Thanks for your report. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com
Re: uppercase database name in backup & restore in pgagmin 1.12.2 windows give errors
From
Guillaume Lelarge
Date:
Le 09/01/2011 18:53, Guillaume Lelarge a écrit : > Le 09/01/2011 18:13, Doug Easterbrook a écrit : >> hi there: >> >> I know this is for bug reports, so I'll report the one I've run into on windows. I haven't tried OSX as I normallydo command line to backup and restore databases. >> >> platform: windows >> >> pgdmin version 1.12.2 >> >> the issue: >> >> if the database name that you create is in mixed case and you try to restore it using right-click restore, the commandin the pgadmin window will escape the database name but pg_Restore will not restore it. >> >> If I change the database name to be all lower case and restore, it works (and then I can change it to upper case). >> > > Yes, we are aware of this issue. I'm working on this. > I just pushed the fix. It should be available in next minor release. -- Guillaumehttp://www.postgresql.frhttp://dalibo.com