Thread: psql dumping

psql dumping

From
Wim Kerkhoff
Date:
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

Re: [GENERAL] psql dumping

From
Stephane Bortzmeyer
Date:
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).





Re: [GENERAL] psql dumping

From
Wim Kerkhoff
Date:
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