Re: Postgresql localhost connection url?
Re: Postgresql localhost connection url?
- Subject: Re: Postgresql localhost connection url?
- From: Theodore Petrosky <email@hidden>
- Date: Mon, 03 Mar 2014 01:17:49 -0500
BTW, if you go to the terminal and run psql, you should be able to connect to the database with:
psql wonderbook
this is what I get with a database on my localhost:
psql astrafficdb
psql (9.2.4)
Type "help" for help.
astrafficdb=#
if you don't get this in the terminal, something needs to be fixed in your postgresql configuration.
Ted
On Mar 2, 2014, at 11:45 PM, Kevin Spake <email@hidden> 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 (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden