From ruby-talk Mon Oct 01 15:15:48 2007 From: "Caleb Tennis" Date: Mon, 01 Oct 2007 15:15:48 +0000 To: ruby-talk Subject: Re: Connecting to PostgreSQL Database Message-Id: <48681.192.168.2.101.1191251315.squirrel () www ! aei-tech ! com> X-MARC-Message: https://marc.info/?l=ruby-talk&m=119125182009811 > 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.