473,326 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

psql


Hello:

I have postgreSQL 7.4.1 installed, but I can't start psql (I was able to
start psql a few weeks ago...)
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so.4: undefined symbol: BC

Anyone knows what is happening?
Thank you,
Carlos
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
10 2123
On Tuesday 22 June 2004 11:11 am, Carlos Ojea Castro wrote:
I have postgreSQL 7.4.1 installed, but I can't start psql (I was able to
start psql a few weeks ago...)
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so.4: undefined symbol: BC


You might already have postgresql preinstalled and have improperly upgrade it?
Or, you might have more than one version installed.

just shooting some possibilities,
Vams

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2
Vams wrote:
On Tuesday 22 June 2004 11:11 am, Carlos Ojea Castro wrote:
I have postgreSQL 7.4.1 installed, but I can't start psql (I was able to
start psql a few weeks ago...)
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so.4: undefined symbol: BC


You might already have postgresql preinstalled and have improperly upgrade it?
Or, you might have more than one version installed.

just shooting some possibilities,
Vams

I made 'apt-get install postgresql', but it was an old version, so I
purged it and then I compile and install 7.4.1 from source...

This is the output of 'dpkg -s postgresql':
debian-ojea:/home/carlos# dpkg -s postgresql
Package: postgresql
Status: purge ok not-installed
Priority: optional
Section: misc

But postgresql is installed:
carlos@debian-ojea:~$ /usr/local/pgsql/bin/postmaster -D
/home/carlos/programacion/compulab/buques/database/
LOG: database system was shut down at 2004-06-22 17:44:05 CEST
LOG: checkpoint record is at 0/289F6F78
LOG: redo record is at 0/289F6F78; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 735362; next OID: 17869
LOG: database system is ready

So, do you know what can I do to correct the problem?
Thank you, regards
Carlos
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #3
Carlos Ojea Castro writes
/usr/lib/postgresql/bin/psql: relocation error:

The location suggests it's the psql from the postgresql-client
debian package.
debian-ojea:/home/carlos# dpkg -s postgresql
Package: postgresql
Status: purge ok not-installed
Priority: optional
Section: misc

But postgresql is installed:
carlos@debian-ojea:~$ /usr/local/pgsql/bin/postmaster -D


You probably need to purge the postgresql-client package
as well, so that your shell will find /usr/local/pgsql/bin/psql
which should be the one that you installed from source.

--
Daniel.
PostgreSQL-based mail storage and user agent:
http://sourceforge.net/projects/manitou-mail

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #4
Daniel Verite wrote:
You probably need to purge the postgresql-client package
as well, so that your shell will find /usr/local/pgsql/bin/psql
which should be the one that you installed from source.


I believe there is a "backports" repository with up-to-date versions you
can just apt-get though. Any Debianites like to go on the record as to
how to set that up?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #5
Carlos Ojea Castro <ca********@leveltelecom.es> writes:
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so.4: undefined symbol: BC

I made 'apt-get install postgresql', but it was an old version, so I
purged it and then I compile and install 7.4.1 from source...


Did you upgrade readline since then? Because this sure looks like
readline's problem not ours.

The only thing I can think of is to rebuild Postgres and see if it works
better. (You might as well update to PG 7.4.3 while you're at it.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #6
Daniel Verite wrote:
Carlos Ojea Castro writes
/usr/lib/postgresql/bin/psql: relocation error:

The location suggests it's the psql from the postgresql-client
debian package.
debian-ojea:/home/carlos# dpkg -s postgresql
Package: postgresql
Status: purge ok not-installed
Priority: optional
Section: misc

But postgresql is installed:
carlos@debian-ojea:~$ /usr/local/pgsql/bin/postmaster -D


You probably need to purge the postgresql-client package
as well, so that your shell will find /usr/local/pgsql/bin/psql
which should be the one that you installed from source.


THAT WAS IT !!!
I made 'dpkg -r postgresql-client' and then I made another install from
source.... and it works !!

Thank you very much,
Carlos

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #7

Hello:

I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.

Am I missing something?

Regards,
Carlos

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #8
On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.


Probably a silly question, but have you got a dbExpress driver for
Postgres? The only one I know is the VitaVoom (commercial) one at
www.vitavoom.com.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #9
Raymond O'Donnell wrote:
On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.
Probably a silly question, but have you got a dbExpress driver for
Postgres? The only one I know is the VitaVoom (commercial) one at
www.vitavoom.com.

I use a postgresql driver, and I think that works because SQLConnection
object is active (I also made queries a few weeks ago, but I don't know
why I get this error now).

Regards,
Carlos
--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 23 '05 #10
On Tue, 29 Jun 2004 12:28:57 +0100, "Raymond O'Donnell" <ro*@iol.ie> wrote:
On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:
I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.


Probably a silly question, but have you got a dbExpress driver for
Postgres? The only one I know is the VitaVoom (commercial) one at
www.vitavoom.com.


Kylix has one included. vitavoom has the only windows one.

What pg version? I found I needed to use an older libpq.so to stop the
access violations. The 7.4 one didn't work too well with borland's
aging dbxpress driver.

klint.

+---------------------------------------+-----------------+
: Klint Gore : "Non rhyming :
: EMail : kg@kgb.une.edu.au : slang - the :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: Daniel Schuchardt | last post by:
Hi @ all, i'm sure there was a psql-function to transfere my Blob-Data to the server but I can't remember. I have a script like this : UPDATE xy SET z = lo_import('localpath_and_file'); ...
4
by: Phil Campaigne | last post by:
Hi All, I just installed postgresql 7.3.4 as an upgrade to 7.3.2 and all went well untill I tried to log into a database that I successfully created. Here are the steps in question: bash-2.05b$...
7
by: Willem Herremans | last post by:
I am developing a client application for postgreSQL in Tcl/Tk (see http://gborg.postgresql.org/project/pfm ). It mainly uses PgTcl or pgintcl. I don't have any problems with those, but I am also...
4
by: Brendan Jurd | last post by:
Hello all, I just wanted to pass on some information about compatibility between the psql client and the postgres server. On a particular network, my workstation and the server are both debian...
15
by: Dino Vliet | last post by:
Hi folks, probably this is a question you've heard so many times but I wasn't able to find a solution to it. I'm using a shell script to create a textfile for me. It looks like...
1
by: Josué Maldonado | last post by:
Hello List, I'm having this issue with beta 8.0 C:\pgsql\bin>pg_dump -U postgres farmacia > xfar.sql Password: C:\pgsql\bin>psql -U postgres farmacia2 < xfar.sql Password: psql: FATAL: ...
2
by: Russ Brown | last post by:
Hello, Today I tried connecting to my database locally via psql. I got the usual welcome & basic help messages, but it never got to the prompt: it just hung. So I checked top and the psql...
33
by: John Sidney-Woollett | last post by:
With the advent of postgres v8, would it be possible to change the default behaviour of psql from AUTOCOMMIT=ON to AUTOCOMMIT=OFF ? Although this might break backward compatibility, it might be...
2
by: Patrick Hatcher | last post by:
Just installed and started Pg8.0 beta 2 When I tried to connect via psql, I received an error message: $ psql -Upostgres template1 psql: relocation error: psql: undefined symbol:...
3
by: oksofar | last post by:
Hello - I'm running PG 8.1 on Windows XP. I've installed the server to run as a service. The psql command fails to connect to the server, although I can connect with other clients. When I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.