On Oct 1, 9:15 am, "Caleb Tennis" <ca... / aei-tech.com> wrote:
> > 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', '')
>
> 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?