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.
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
RE: Postgresql connection
Hello Giovanni,
The Palo server listens to port 7777, see also palo.ini file.
Regards,
Stephanie
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