Connecting to PostGreSQL on same machine: Mac OSX
psahores at easynet.fr
Mon Dec 13 03:20:49 EST 2004
If you run in troubles with the Postgres for Mac OS X installation
process, take time to reinstall from scratch in using the Mark
Liyanage's Postgres.DMG and How-to that you can find at
Le 13 déc. 04, à 01:45, Sivakatirswami a écrit :
> ;-( things are getting worse instead of better. Now I seemed to have
> shot myself in the foot and cannot even get the postmaster/server to
> start up at all...let alone connect with rev... OK, following all the
> advice as bes as I can and also the postgres docs....here's where i
> OK first of all Pierre was correct, after initdb on installtion, the
> pg_hba file was in fact automatically installed with two client
> authenticate records as follows:
> # TYPE DATABASE USER IP-ADDRESS IP-MASK
> local all all
> # IPv4-style local connections:
> host all all 127.0.0.1 255.255.255.255
> # I infer from this that "localhost" should work automatically,
> assuming we can start the server and tcp/ip connections are allowed...
> So I then edited postmaster.conf and uncommented only three lines,
> tcpip, max_connections and port....
> # - Connection Settings -
> tcpip_socket = true
> max_connections = 50
> # note: increasing max_connections costs about 500 bytes of
> # memory per connection slot, in addition to costs from
> # and max_locks_per_transaction.
> #superuser_reserved_connections = 2
> port = 5432
> #unix_socket_directory = ''
> #unix_socket_group = ''
> #unix_socket_permissions = 0777 # octal
> #virtual_host = '' # what interface to listen on;
> defaults to any
> #rendezvous_name = '' # defaults to the computer name
> # - Security & Authentication -
> #authentication_timeout = 60 # 1-600, in seconds
> #ssl = false
> #password_encryption = true
> #krb_server_keyfile = ''
> #db_user_namespace = false lines
> (and more lines, all commented out)
> OK, that seems to fulfill everyone's guidance... but:
> katir:/usr/local/pgsql/data postgres$ pg_ctl -D /usr/local/pgsql/data
> -i -l logfile start
> katir:/usr/local/pgsql/data postgres$
> katir:/usr/local/pgsql/bin postgres$ ./psql katir_test
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> katir:/usr/local/pgsql/bin postgres$
> So, no I cannot even start up the server at all.
> On Dec 12, 2004, at 9:08 AM, Hershel Fisch wrote:
>> Hi , in order to run thru a tcp/ip connection it has to be enabled
>> first , to do so eithre you enable the tcp/ip or you start it
>> with an -I flag.
>> su - postgres
>> postgres% "/usr/local/bin/postmaster -D /usr/local/pgsql/data –I" (
>> this is the -I flag you enter)
>> Hershel Fisch
> use-revolution mailing list
> use-revolution at lists.runrev.com
Bien cordialement, Pierre Sahores
100, rue de Paris
F - 77140 Nemours
psahores+ at +easynet.fr
sc+ at +sahores-conseil.com
GSM: +33 6 03 95 77 70
Pro: +33 1 64 45 05 33
Fax: +33 1 64 45 05 33
WEB/EAI services & ACID DB over IP
"Mutualiser les deltas de productivité"
More information about the use-livecode