SQL Power Business Intelligence Productivity Tools

SQL Power Software Forum
SQL Power Software Forum
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Connecting to a postgres database on linux  XML
Forum Index » SQL Power Architect Technical Support
Author Message
[Post New]2016-06-10 16:34:10
    Subject: Connecting to a postgres database on linux
[Up]
bbgoldin


Joined: 2016-06-10 15:54:19
Messages: 1
Offline
I am trying this product for the first time
1)I added the jdbc driver
2) chose postgres as my database
3) added the database name and user name

I get: org.postgresql.util.PSQLException: The connection attempt failed.

I need help please!
[Post New]2016-07-15 09:55:53
    Subject: Re:Connecting to a postgres database on linux
[Up]
Kirti M


Joined: 2015-02-12 16:21:34
Messages: 71
Offline
Hi bbgoldin,

Power Architect comes with jdbc driver for postgreSQL.(you can find it under jdbc_drivers folder of power- architect). check the user preferences. see the attached screenshot for this.

To create a new connect right click on 'PlayPen Database' >'Add Source Connection' >'New Connection' in a left panel.
select Database Type as PostgreSQL, see the attached screenshot for more information.
After filling all information click on test connection. Hope this help you.

- Kirti
[Thumb - Screen Shot For New Connection.png]
 Filename Screen Shot For New Connection.png [Disk] Download
 Description Screenshot for new connection
 Filesize 44 Kbytes
 Downloaded:  2162 time(s)

[Thumb - user_preference_for_PostgreSQL.png]
 Filename user_preference_for_PostgreSQL.png [Disk] Download
 Description User Preferences for PostgreSQL
 Filesize 76 Kbytes
 Downloaded:  2136 time(s)

 
Forum Index » SQL Power Architect Technical Support
Go to:   
Powered by JForum 2.1.8 © JForum Team