LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat
User Name
Password
Red Hat This forum is for the discussion of Red Hat Linux.

Notices


Reply
  Search this Thread
Old 12-06-2003, 04:10 PM   #1
Manuel Tejada
Member
 
Registered: Jun 2002
Location: Lima, PERU
Distribution: Red Hat
Posts: 35

Rep: Reputation: 15
Connectting PostrgreSQL with GUI pgaccess fail


Red Hat 9 in a Intel Petium III box

Hello everybody

I start the PostgreSQL with the script:
$/etc/rc.d/init.d/posgresql start

When I try to connect PostgreSQL with GUI pgaccess with the command:

$ pgaccess mydatabase

I get this oupput:

"Segment violate"

I verified the existence of pgaccess with the command:"find / -name pgaccess* -print" and this is the output I get:

/usr/bin/pgaccess
/usr/share/pgsql/pgaccess
/usr/share/man/man1/pgaccess/pgaccess.1.gz

I must tell you that I have setup "tcpip-socket=true" in the configuration file of PostgreSQL, because I believe with this setting is same as start the postmaster with "i" option.

Do you know why I can not connect to PostgreSQL with pgaccess?
 
Old 12-08-2003, 06:06 AM   #2
yuray
Member
 
Registered: Apr 2003
Location: Russia, Khotkovo
Distribution: Debian
Posts: 146

Rep: Reputation: 15
First, check postgres is working with
psql -U user -h host database
 
Old 12-11-2003, 07:28 PM   #3
Manuel Tejada
Member
 
Registered: Jun 2002
Location: Lima, PERU
Distribution: Red Hat
Posts: 35

Original Poster
Rep: Reputation: 15
Yes It is working
 
Old 12-12-2003, 05:13 AM   #4
yuray
Member
 
Registered: Apr 2003
Location: Russia, Khotkovo
Distribution: Debian
Posts: 146

Rep: Reputation: 15
Try to update version pgaccess and depending packages.
Sorry, I was install pgacces from sources.
 
Old 12-14-2003, 12:59 AM   #5
jdruin
Member
 
Registered: Jul 2003
Location: Louisville aka Derby City
Distribution: WinXP SP2 and SP3, W2K Server, Ubuntu
Posts: 313

Rep: Reputation: 30
Setting the "tcpip-socket=true" is not the same as starting with the "i" option, they are both neccesary and separate steps.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
pgaccess johan grav Linux - Software 1 06-02-2007 03:21 PM
How to uninstall pgaccess? Manuel Tejada Red Hat 2 12-19-2003 08:38 PM
Connectting to Samba shares lapthorn Linux - Newbie 1 12-19-2003 04:52 AM
PGaccess orims Linux - Software 0 05-20-2003 09:28 AM
connectting to a port 3270 aqoliveira Linux - Software 2 10-25-2002 10:49 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Red Hat

All times are GMT -5. The time now is 08:34 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration