You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Giovanni

Intermediate

  • "Giovanni" started this thread

Posts: 6

Date of registration: Apr 6th 2006

  • Send private message

1

Wednesday, August 8th 2007, 9:06am

Postgresql connection

Dear all,

I need to connect Palo to a Postgresql db and I need a hint to define the connection to the DB.
What do you use to define the "Server" connection ?
I have tried the following but it doesn't work.

Name:xxxxxxxxxxxx
Server: localhost
Port: 5432
User:xxxxxxxx
Passw:xxxxxxxx

For the server I tried also jdbc:postgresql://localhost:5432/db name
but still nothing happen when I do the connection test.

Any suggestion will be very helpful to me
Giovanni

Posts: 540

Date of registration: Oct 23rd 2006

Location: Freiburg

  • Send private message

2

Wednesday, August 8th 2007, 10:19am

RE: Postgresql connection

Hello Giovanni,

The Palo server listens to port 7777, see also palo.ini file.

Regards,
Stephanie

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

3

Wednesday, August 8th 2007, 12:38pm

RE: Postgresql connection

Hi,
The server connection definition defines only connections to PALO Servers.

If you like to connect to your sql-DB e.g. to import data from there with the PALO import wizard you can choose a odbc connection via DSN there.

You have to create this DSN before.

Holger

Rate this thread