Thread: 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 start
>
> postmaster 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

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

Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
> 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?

You need bison 1.875 or later to build current Postgres.

            regards, tom lane