[prev in list] [next in list] [prev in thread] [next in thread]
List: ruby-talk
Subject: Re: Connecting to PostgreSQL Database
From: "Caleb Tennis" <caleb () aei-tech ! com>
Date: 2007-10-01 15:15:48
Message-ID: 48681.192.168.2.101.1191251315.squirrel () www ! aei-tech ! com
[Download RAW message or body]
> 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.
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic