Hello Katir,
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 <http://www.entropy.ch/software/macosx/postgresql/>.
Best Regards,
Pierre
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 stand:
===========
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:
pg_hba.conf
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
# IPv4-style local connections:
host all all 127.0.0.1 255.255.255.255 trust
# 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 shared
# memory per connection slot, in addition to costs from shared_buffers
# 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.
??
Sivakatirswami
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
password
postgres% "/usr/local/bin/postmaster -D /usr/local/pgsql/data –I" ( this is the -I flag you enter)
Hershel Fisch_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
-- Bien cordialement, Pierre Sahores
100, rue de Paris F - 77140 Nemours
[EMAIL PROTECTED] [EMAIL PROTECTED]
GSM: +33 6 03 95 77 70 Pro: +33 1 64 45 05 33 Fax: +33 1 64 45 05 33
<http://www.sahores-conseil.com/>
WEB/EAI services & ACID DB over IP "Mutualiser les deltas de productivité"
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
