Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] problem with PostgreSQL 6.5 on Linux

From: Howie <caffeine(at)toodarkpark(dot)org>
To: Dan Wilson <dan_wilson(at)geocities(dot)com>
Cc: postgres <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] problem with PostgreSQL 6.5 on Linux
Date: 1999-06-26 01:46:17
Message-ID: Pine.LNX.3.96.990626013755.14179I-100000@rabies.toodarkpark.org (view raw or flat)
Thread:
Lists: pgsql-general
On Fri, 25 Jun 1999, Dan Wilson wrote:

> I ran into the same problem and it turned out to be an outdated version of
> psql.  Check your path to see if you are accessing the correct version of
> psql, pg_dump etc..

it is; ive made sure of that.  stripped all the permissions off of the
entire 6.4.2 install tree, in fact.

manually cat'ing $PGDATA/PG_VERSION shows that its indeed "6.4" instead of
"6.5".  i can manually echo 6.5 >$PGDATA/PG_VERSION, fixing the connection
problem, but i more concerned with why this is occurring. 

as a sidenote, 'initdb' doesnt appear to be creating the proper pg_*
tables; pg_user doesnt exist.  im starting to think the compile went
bad...

there also seems to be an ongoing problem with psql and importing TEXT
fields via COPY.  i can import a relatively large (~490k entries ) table
w/o text fields just fine, but importing an 11k entry table _with_ text
entries fails with a buffer overflow.  this has happened since pgsql 6.3.2

---
Howie <caffeine(at)toodarkpark(dot)org>   URL: http://www.toodarkpark.org    
"The distance between insanity and genius is measured only by success."


In response to

pgsql-general by date

Next:From: HowieDate: 1999-06-26 02:13:20
Subject: Re: [GENERAL] problem with PostgreSQL 6.5 on Linux [solved]
Previous:From: Keith R. DavisDate: 1999-06-26 00:40:22
Subject: Administration Wizards ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group