Installtion error
Dear sir,
Sir last one week i am try to install PostgreSQL in
Mac os x 10.2 .I dowm loaded PostgreSQL 7.3 from net
and i installed it in 'ampleuser', my login (in
dir:Library/PostgreSQL).
After that i set the paths in follwing manner.And it
successfully starting the postmaster also.But when i
try to create the database its giving the error.
Sir what is the error and plez give me solution
for it.
--------------------------
Mahesh-Ss-Computer:/Library/PostgreSQL] root# chown
ampleuser /Library/PostgreSQL/data
Mahesh-Ss-Computer:/Library/PostgreSQL] root# su -l
ampleuser
Mahesh-Ss-Computer:~] ampleuser%
[Mahesh-Ss-Computer:~] ampleuser% setenv PATH
${PATH}:/Library/PostgreSQL/bin
[Mahesh-Ss-Computer:~] ampleuser% setenv PGDATA
/users/ampleuser/data
[Mahesh-Ss-Computer:~] ampleuser%
/Library/PostgresqL/bin/pg_ctl -D
/users/ampleuser/data -l logfile start
postmaster successfully started
[Mahesh-Ss-Computer:~] ampleuser% createdb 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"?
createdb: database creation failed
________________________________________________________________________
Missed your favourite TV serial last night? Try the new, Yahoo! TV.
visit http://in.tv.yahoo.com
[Mahesh-Ss-Computer:~] ampleuser%
/Library/PostgresqL/bin/pg_ctl -D
/users/ampleuser/data -l logfile startpostmaster successfully started
Postgres will actually be spitting the error to a file called
"logfile", while saying it was successful to STDOUT. Your error is in
there.
Alex
--
alex avriette, unix geek for hire
http://envy.posixnap.net/
alex@posixnap.net
[Mahesh-Ss-Computer:~] ampleuser% createdb 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"?
createdb: database creation failed
I am not sure about mac, but still i suppose, you might have to add below
entry in your pg_hba.conf file to set it right:
host all all 127.0.0.1 255.255.255.255 trust
regards,
bhuvaneswaran
Import Notes
Resolved by subject fallback
Hello
I can't compile csv version on my linux 7.3. Previous versions I compiled
without problems. First errors is in linking SUBSYS.o.
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -L../../src/port
-Wl,-rpath,/usr/local/pgsql/lib -export-dynamic access/SUBSYS.o
bootstrap/SUBSYS.o catalog/SUBSYS.o parser/SUBSYS.o commands/SUBSYS.o
executor/SUBSYS.o lib/SUBSYS.o libpq/SUBSYS.o main/SUBSYS.o nodes/SUBSYS.o
optimizer/SUBSYS.o port/SUBSYS.o postmaster/SUBSYS.o regex/SUBSYS.o
rewrite/SUBSYS.o storage/SUBSYS.o tcop/SUBSYS.o utils/SUBSYS.o -lz
-lreadline -ltermcap -lcrypt -lresolv -lnsl -ldl -lm -lbsd -lpgport -o
postgres
parser/SUBSYS.o: In function `base_yylex':
parser/SUBSYS.o(.text+0xc065): undefined reference to `__ctype_b'
parser/SUBSYS.o(.text+0xc078): undefined reference to `__ctype_tolower'
parser/SUBSYS.o: In function `ScanKeywordLookup':
parser/SUBSYS.o(.text+0xceda): undefined reference to `__ctype_b'
commands/SUBSYS.o: In function `case_translate_language_name':
commands/SUBSYS.o(.text+0x9a2c): undefined reference to `__ctype_tolower'
commands/SUBSYS.o: In function `assign_timezone':
commands/SUBSYS.o(.text+0x26cd4): undefined reference to `__ctype_b'
nodes/SUBSYS.o: In function `_outToken':
nodes/SUBSYS.o(.text+0x9e10): undefined reference to `__ctype_b'
nodes/SUBSYS.o: In function `nodeTokenType':
...
...
I have gcc 3.2.2, bison 1.2.8, lex 2.5.4. (configure I run without
params) Have I upgrade some libs or tools?
Thank you
Pavel
