Re: [pgsql] connectivity problem

The file has to be only on the remote server (the one running the database) or on my server also? "Jurgen Stroo" <blurg@JurgenStroo.com> wrote in message news:Pine.LNX.4.58.0407181505320.19290@megalosaurus.recast.nl... > Well, then something went wrong with your postgres installation. > This file should be somewhere in /etc (/etc/postgresql/pg_hba.conf for > example). If this is your own system try to search for it, like this > for example: > > find /etc -name pg_hba.conf > > If it is missing, you can create it yourself, but personally I think you > should check WHY you don't have it, may be something more is missing. > > But to connect to a postgres database I think you need to read some more > about postgres at least, so you know how it works and you can decide > which way you want to connect to postgres (if you want to use the safe ident authentication, for example) > > I can paste some default entries into this mail for you (version 7.4.3): > > # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD > # Database administrative login by UNIX sockets > local all postgres ident sameuser > # > # All other connections by UNIX sockets > local all all ident sameuser > # > # All IPv4 connections from localhost > host all all 127.0.0.1 255.255.255.255 ident sameuser > # > # All IPv6 localhost connections > host all all ::1 > ffff:ffff:ffff:ffff:ffff:ffff: > ffff:ffff ident sameuser > host all all ::ffff:127.0.0.1/128 ident > sameus > er > # > # reject all other connection attempts > host all all 0.0.0.0 0.0.0.0 reject > > > You can have a free read about postgresql at commandprompt.com, there is > a O'Reilly book to be found there, freely available through the Public > license. > > Good luck! > Ugh! Blurg. > > -------------------------------------------------------------------------- - > "When a man sits with a pretty girl for an hour, it seems like a minute. > But let him sit on a hot stove for a minute and it's longer than any hour. > That's relativity." [A. Einstein, 1938] > > http://jurgenstroo.com > > This one time, at band camp, Ciprian Constantinescu said: > > > I have the following code > > > > [CODE] > > <?php > > $dbconn3 = pg_connect("host=somehost port=5432 dbname=adatabase > > user=postgres"); > > ?> > > [/CODE] > > > > And when i run the script I get " Warning: pg_connect() > > [function.pg-connect]: Unable to connect to PostgreSQL server: FATAL: > > missing or erroneous pg_hba.conf file" > > > > I have searched for pg_hba.conf, but I don't have it. Where should it be and > > what should it contain? > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > >