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 Nabble.co
On Sat, Jun 22, 2013 at 12:19 AM, 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 Stephe
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
Hi,
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 this
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,
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
I could be wrong, but shouldn't the owner of .pgpass be postgres?
On Mon, Jun 24, 2013 at 3:17 PM, Ziggy Skalski wrote:
> 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 w
On 06/21/2013 04:29 PM, Stephen Rasku wrote:
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver 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
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver 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 you are doing a crea
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 c
On Fri, Jun 21, 2013 at 3:33 PM, Raymond O'Donnell 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
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 Ju
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
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 c
14 matches
Mail list logo
