Have you tried connecting using psql over TCP/IP? psql -h 127.0.0.1
On Tue, Aug 25, 2009 at 06:00:04PM -0600, Bryan Richardson wrote: > Hmmm... I've edited my pg_hba.conf file to allow ident sameuser for > 127.0.0.1/32 and postgres is listening on 127.0.0.1:5432, and how I get a > 'The driver encountered an error: no connection available' error when I try > to connect using the following: > > adapter: jdbcpostgres > url: postgres://localhost:5432/<dbname> > > Any ideas? > > On Tue, Aug 25, 2009 at 5:26 PM, Ryan L. Bell <[email protected]> wrote: > > > > > It's not possible without changes to pg_hba.conf > > > > You need to setup connections from 127.0.0.1/32 to trust. > > > > /Ryan > > > > > > > > On Tue, Aug 25, 2009 at 04:58:57PM -0600, Bryan Richardson wrote: > > > Guess I should have stated that I did try a couple of different > > > configurations but to no avail. Can't remember all the configs I tried, > > but > > > they were along the lines of specifying jdbcpostgresql as the adapter, > > > specifying jdbc as the adapter and providing a url of > > > jdbc:postgresql:<dbname> and a driver of org.postgresql.Driver, > > specifying a > > > socket of /var/run/postgresql, etc. > > > > > > On Tue, Aug 25, 2009 at 2:59 PM, Nick Sieger <[email protected]> > > wrote: > > > > > > > On Aug 25, 2009, at 15:44 , Bryan Richardson wrote: > > > > > > > > Hello all, > > > >> > > > >> When I use postgresql with a regular Rails app, I can simply provide > > the > > > >> adapter and database name and ActiveRecord knows to try and access > > Postgres > > > >> on the local machine using the user Rails is running under. Thus, I > > don't > > > >> have to provide a password. Is this possible with the JDBC version? > > > >> > > > > > > > > Come to think of it, I'm not sure. It might work. Try it? > > > > > > > > /Nick > > > > > > > > _______________________________________________ > > > > Jruby-extras-devel mailing list > > > > [email protected] > > > > http://rubyforge.org/mailman/listinfo/jruby-extras-devel > > > > > > > > > _______________________________________________ > > > Jruby-extras-devel mailing list > > > [email protected] > > > http://rubyforge.org/mailman/listinfo/jruby-extras-devel > > > > -- > > > > Ryan L. Bell > > http://kofno.wordpress.com > > http://twitter.com/kofno > > http://github.com/kofno > > _______________________________________________ > > Jruby-extras-devel mailing list > > [email protected] > > http://rubyforge.org/mailman/listinfo/jruby-extras-devel > > > _______________________________________________ > Jruby-extras-devel mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/jruby-extras-devel -- Ryan L. Bell http://kofno.wordpress.com http://twitter.com/kofno http://github.com/kofno _______________________________________________ Jruby-extras-devel mailing list [email protected] http://rubyforge.org/mailman/listinfo/jruby-extras-devel
