psql dumping

Started by Wim Kerkhoffover 26 years ago3 messagesgeneral
Jump to latest
#1Wim Kerkhoff
wim@netmaster.ca

Hi,

I am having problems running psql: it is segfaulting on me. The database is
working, because I was able to create a table using a CGI script and the
Postgres module.

What is happening here?

-------------------------------------------
gateway:~/data/base$ createdb test
gateway:~/data/base$ psql test
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.95]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: test

Segmentation fault
gateway:~/data/base$
--------------------------------------------

(Debian 2.2)

Thanks,

/---------------------------
| Wim Kerkhoff
| wim@netmaster.ca
| www.canadianhomes.net/wim
| ICQ: 23284586

#2Wim Kerkhoff
wim@netmaster.ca
In reply to: Wim Kerkhoff (#1)
Re: [GENERAL] psql dumping

Yea, I know it is unstable, but I use it because Debian 2.1 is old! I figure
it is one of the problems with bash & libreadlineg2, because psql started fine
with 'psql -n testdb', but then of course, I lose the ability to edit the
command line and history. Owell, until I upgrade bash that is what I get.

Thanks,
-Wim.

On 24-Aug-99 Stephane Bortzmeyer wrote:

On Monday 23 August 1999, at 4 h 45, the keyboard of Wim Kerkhoff
<wim@netmaster.ca> wrote:

Segmentation fault
gateway:~/data/base$
--------------------------------------------

(Debian 2.2)

Are you aware that Debian 2.2 has not been released? If you used the
'unstable' branch (the future 2.2), this is called 'unstable' for a
reason(the libc is moving fast)... You should not use it unless you subscribe
to debian-devel, or, at least, debian-devel-announce.

But, on my Debian 'unstable', it works:

$ createdb test
$ psql test
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.95]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: test

test=>

Hence the question: what are your environment variables? And the versions of
Debian packages? (postgresql, libc6, etc).

/---------------------------
| Wim Kerkhoff
| wim@netmaster.ca
| www.canadianhomes.net/wim
| ICQ: 23284586

#3Stephane Bortzmeyer
bortzmeyer@pasteur.fr
In reply to: Wim Kerkhoff (#1)
Re: [GENERAL] psql dumping

On Monday 23 August 1999, at 4 h 45, the keyboard of Wim Kerkhoff
<wim@netmaster.ca> wrote:

Segmentation fault
gateway:~/data/base$
--------------------------------------------

(Debian 2.2)

Are you aware that Debian 2.2 has not been released? If you used the 'unstable' branch (the future 2.2), this is called 'unstable' for a reason(the libc is moving fast)... You should not use it unless you subscribe to debian-devel, or, at least, debian-devel-announce.

But, on my Debian 'unstable', it works:

$ createdb test
$ psql test
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.95]

type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: test

test=>

Hence the question: what are your environment variables? And the versions of Debian packages? (postgresql, libc6, etc).