Re: [BUGS] BUG #2634: path requires double \\ for WAL

#1

Hans Postma wrote:

Quote:

The following bug has been logged online:

Bug reference: 2634
Logged by: Hans Postma
Email address: hans (AT) aeteurope (DOT) nl
PostgreSQL version: 8.1
Operating system: Windows XP VM virtual server
Description: path requires double \\ for WAL archiving
Details:

Hi there
Trying to use WAL-archiving, I discovered that to decribe the path where I
want the copies of the WAL-file to go, I need to enter the following in the
PostgreSQL.conf file:

archive_command = 'copy "%p" C:\\<folder>\\" %f" '

I am using a Windows 2000 (version 5 SP4) virtual server (VM 5.0.0 build
13124) running on Windows XP.

yours, Hans Postma

Yes, this is required because we use backslashes for escapes. The
backslashing can be turned off in 8.2.

--
Bruce Momjian bruce (AT) momjian (DOT) us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2

On Mon, 2006-09-18 at 13:37 -0400, Bruce Momjian wrote:

Quote:

Yes, this is required because we use backslashes for escapes. The
backslashing can be turned off in 8.2.

So the postgresql.conf setting "standard_conforming strings" that turns
off backslash escaping affects the interpretation of other
postgresql.conf settings?

What if you have a path set for archive_command and then you change the
standard_conforming_strings GUC and SIGHUP the server? Will the path be
incorrect?

Regards,
Jeff Davis

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#3

Jeff Davis <pgsql (AT) j-davis (DOT) com> writes:

Quote:

So the postgresql.conf setting "standard_conforming strings" that turns
off backslash escaping affects the interpretation of other
postgresql.conf settings?

No, it doesn't. Backslashes are still escapes within postgresql.conf.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] BUG #2634: path requires double \\ for WAL

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] BUG #2634: path requires double \\ for WAL - 09-18-2006 , 12:46 PM

Re: [BUGS] BUG #2634: path requires double \\ for WAL - 09-18-2006 , 01:32 PM

Re: [BUGS] BUG #2634: path requires double \\ for WAL - 09-18-2006 , 01:38 PM