Connecting to PostgreSQL Database

Hello,

I am trying to move data from one postgres database to another using
the Ruby postgres adapter. However, I keep getting a password
authentication error whenever I try. My sysadmin keeps indicating that
there is no password on that database and the Rails apps I use don’t
indicate any password in database.yml and work fine. Am I being lied
to or is there some other secret I don’t know? Thanks for any help or
suggestions. Here’s the code I’m using (and line 184 DOES work):

184: db1 = PGconn.connect(‘dbserver1.blah.com’, 5432, ‘’, ‘’,
‘database1_name’, ‘username’, ‘password’)
185: db2 = PGconn.connect(‘dbserver2.blah.com’, 5432, ‘’, ‘’,
‘database2_name’, ‘username’, ‘’)

And here’s the error:

c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/postgres-pr/
connection.rb:55:in initialize': FATAL C28000 MPassword authentication failed for user "username" Fauth.c L395 Rauth_failed (RuntimeError) from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:29:inloop’
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/connection.rb:29:in initialize' from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/postgres-compat.rb:23:innew’
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/postgres-compat.rb:23:in initialize' from DataFetcher.rb:185:inconnect’
from DataFetcher.rb:185

On 10/1/07, Matt W. [email protected] wrote:

184: db1 = PGconn.connect(‘dbserver1.blah.com’, 5432, ‘’, ‘’,
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/connection.rb:29:in loop' from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/connection.rb:29:ininitialize’
from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/
postgres-pr/postgres-compat.rb:23:in new' from c:/ruby/lib/ruby/gems/1.8/gems/postgres-pr-0.4.0/lib/ postgres-pr/postgres-compat.rb:23:ininitialize’
from DataFetcher.rb:185:in `connect’
from DataFetcher.rb:185

Have you tried giving it a nil for the password rather than an empty
string?

V/r
Anthony

184: db1 = PGconn.connect(‘dbserver1.blah.com’, 5432, ‘’, ‘’,
‘database1_name’, ‘username’, ‘password’)
185: db2 = PGconn.connect(‘dbserver2.blah.com’, 5432, ‘’, ‘’,
‘database2_name’, ‘username’, ‘’)

Are you sure that the passwordless connection works okay from the
machine you’re
attempting from? You can configure postgres to only accept connections
from certain
ip addresses for certain users. A lot of times, the default is to allow
passwordless login from localhost, but not from remote hosts.

Turns out I was lied to. There is a password on there. Sorry to
trouble you all.

On Oct 1, 9:15 am, “Caleb T.” [email protected] wrote:

184: db1 = PGconn.connect(‘dbserver1.blah.com’, 5432, ‘’, ‘’,
‘database1_name’, ‘username’, ‘password’)
185: db2 = PGconn.connect(‘dbserver2.blah.com’, 5432, ‘’, ‘’,
‘database2_name’, ‘username’, ‘’)

Are you sure that the passwordless connection works okay from the machine you’re
attempting from? You can configure postgres to only accept connections from certain
ip addresses for certain users. A lot of times, the default is to allow
passwordless login from localhost, but not from remote hosts.

I tried using nil and got a ‘no password specified error’.

Looking at the pg_hba.conf file I see the login I’m using allowed for
both internet IP addresses we have, so it’s not just restricted to
localhost. Any other ideas?

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs