In case someone is facing the same problem again, solution is to add * in
.pgpass in place of ip address.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgpass-being-ignored-tp5760421p5815268.html
Sent from the PostgreSQL - general mailing list archive at
However, when I call createdb, it fails:
$ createdb -h 192.168.1.4 -U postgres --no-password JobSearch
createdb: could not connect to database postgres:
fe_sendauth: no
password supplied
Hi,
isn't your --no-password switch preventing
On 06/24/2013 11:36 PM, Frank Broniewski wrote:
However, when I call createdb, it fails:
$ createdb -h 192.168.1.4 -U postgres --no-password
JobSearch
createdb: could not connect to database postgres:
fe_sendauth: no
password supplied
On Sat, Jun 22, 2013 at 12:19 AM, Stephen Rasku sra...@gmail.com wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
I could be wrong, but shouldn't the owner of .pgpass be postgres?
On Mon, Jun 24, 2013 at 3:17 PM, Ziggy Skalski zskal...@afilias.infowrote:
On 13-06-21 06:19 PM, Stephen Rasku wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password
On 13-06-21 06:19 PM, Stephen Rasku wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Jun
On 06/24/13 10:24, Rebecca Clarke wrote:
I could be wrong, but shouldn't the owner of .pgpass be postgres?
The owner of ~/.pgpass is whoever owns ~ (the home directory of that user).
And ~/.pgpass must have permissions 0600 in order for libpq to actually
use it.
Jan
On Mon, Jun 24,
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Jun 14:48 /Users/Stephen/.pgpass
However, when I
On 21/06/2013 23:25, Stephen Rasku wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21
On 06/21/2013 03:25 PM, Stephen Rasku wrote:
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21
On Fri, Jun 21, 2013 at 3:33 PM, Raymond O'Donnell r...@iol.ie wrote:
What's in your server's pg_hba.conf file?
# TYPE DATABASEUSERCIDR-ADDRESSMETHOD
#@remove-line-for-nolocal@# local is for Unix domain socket connections only
local all all
I am trying to write a script that will create and populate a
database. I don't want to enter a password every time so I want to
use a .pgpass file. It has the correct permissions:
$ ls -l $PGPASSFILE
-rw--- 1 Stephen staff 43 21 Jun 14:48 /Users/Stephen/.pgpass
However, when I
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
First are you running the script from the location with .pgpass?
I wasn't but I copied the .pgpass into the local directory and I get
the same results. The correct location is actually in the home
directory.
Second
On 06/21/2013 04:29 PM, Stephen Rasku wrote:
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
First are you running the script from the location with .pgpass?
I wasn't but I copied the .pgpass into the local directory and I get
the same results. The correct
14 matches
Mail list logo