> jdbc:postgresql://localhost/5433/wonderbook
if you want to include a port in a URL, you precede it with a colon localhost:5432 however assuming the database you want to connect to is called 'wonderbook' then the uri is; jdbc:postgresql://localhost/wonderbook or jdbc:postgresql://127.0.0.1/wonderbook you don't add the port here. you must make sure that pg_hba.conf shows: # IPv4 local connections: host all all 127.0.0.1/32 trust basically saying that if anyone from the localhost machine tries to connect, let it and trust the connection. I just checked my postgresql.conf file and I see the line: #listen_addresses = 'localhost' # what IP address(es) to listen on; is commented out so this is the default (to listen on localhost). On Mar 2, 2014, at 11:45 PM, Kevin Spake <sparky0...@yahoo.com> wrote: > Hi there. > > I'm going through the Learning the Wonders book, and I'm at the point where > I've built my first model, and I'm trying to generate the sql to it. My > database is postgresql 9.3. When I hit the "Generate SQL" button I get an > error saying that it can't connect. Postgresql is running on the same > computer, so I'm trying to connect to localhost over port 5433. I can connect > to the database via psql, and pg admin, but not from my app. > > From what I've read, 9.3 should accept tcp/ip connections via localhost by > default, without any configuration change. I've got the jdbc driver in the > libraries folder and it was added to the build path. Maybe my url is wrong? > This is the url I am using: jdbc:postgresql://localhost/5433/wonderbook > > Any suggestions? > > Thanks, > > Kevin > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/tedpet5%40yahoo.com > > This email sent to tedp...@yahoo.com _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
