pgAgent Database Name Limitation

From: Martin French <Martin(dot)French(at)romaxtech(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: pgAgent Database Name Limitation
Date: 2012-09-04 09:35:36
Message-ID: OF1CB565B4.B9CE79AA-ON80257A6F.00341771-80257A6F.0034B2B4@romaxtech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi all,

I've come across an issue within pgAgent whereby it cannot/will not
connect to a database where there is a space in the name.
(I know that typically pgAgent should run within the postgres db to allow
pgAdmin job management, however, this is a second pgAgent running with a
specific task set)

I have tried all the following variants:

"dbname='DB With Spaces 1' user=user1"
'dbname="DB With Spaces 1" user=user1'
"dbname=DB With Spaces 1 user=user1"
dbname=DB With Spaces 1 user=user1
"dbname=\'DB With Spaces 1\' user=user1"

etc etc...

All of which return:
ERROR: Primary connection string is not valid!

Anyone know if this a limitation within pgAgent or libpq? I had an odd
thought that this may be because of wxStrings...

I've not yet investigated the source to see how this is being interpreted,
as I thought i'd shout up on here to see If this is a libpq limitation.

Cheers

Martin
=============================================

Romax Technology Limited
Rutherford House
Nottingham Science & Technology Park
Nottingham,
NG7 2PZ
England

Telephone numbers:
+44 (0)115 951 88 00 (main)

For other office locations see:
http://www.romaxtech.com/Contact
=================================
===============
E-mail: info(at)romaxtech(dot)com
Website: www.romaxtech.com
=================================

================
Confidentiality Statement
This transmission is for the addressee only and contains information that
is confidential and privileged.
Unless you are the named addressee, or authorised to receive it on behalf
of the addressee
you may not copy or use it, or disclose it to anyone else.
If you have received this transmission in error please delete from your
system and contact the sender. Thank you for your cooperation.
=================================================

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Akshay Joshi 2012-09-04 09:45:26 Fixed help button crash
Previous Message Dave Page 2012-09-04 09:07:58 Re: Different look and feel of the Documentation on Windows and Linux