LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu
User Name
Password
Ubuntu This forum is for the discussion of Ubuntu Linux.

Notices


Reply
  Search this Thread
Old 09-17-2009, 08:56 AM   #1
rsciw
Member
 
Registered: Jan 2009
Location: Essex (UK)
Distribution: Home: Debian/Ubuntu, Work: Ubuntu
Posts: 206

Rep: Reputation: 44
Problems installing postgresql server on ubuntu


Heyas,

something which strikes me as weird occurs currently when I'm trying to install pgsql on my Ubuntu vps.

I installed it via apt-get:
sudo apt-get install postgresql
that'll give me
Code:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
Suggested packages:
  postgresql-doc-8.3
The following NEW packages will be installed
  postgresql postgresql-8.3 postgresql-client-8.3 postgresql-client-common postgresql-common
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 4834kB of archives.
After this operation, 20.0MB of additional disk space will be used.
Do you want to continue [Y/n]?
so far so good.

When trying to psql, I can't connect, giving me the error
Code:
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
at which I thought I hadn't started the server, though usually they get started after installation.
Nonetheless I executed
sudo /etc/init.d/postgresql-8.3 start

which gave no message on stdout.
running
sudo /etc/init.d/postgresql-8.3 status equally didn't say anything

Then wanted to look at the config file, which is normally in
/etc/postgresql/8.3/main
however that doesn't exist,
same as
/var/lib/postgresql/ doesn't contain anything, only
/etc/postgresql-common/

ok, I thought, maybe need to separately install postgresql-server, but that was never stated, neither on the ubuntu guide page nor elsewhere, which I then checked to see if I missed anything.

executing the install for postgresql-server, I get
Code:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package postgresql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source
E: Package postgresql-server has no installation candidate
So now I'm sitting here without a server and wondering how to get it now.

Is there any solution getting the pgsql-server installed via package manager?

vps is running on ubuntu 8.04 LTS Hardy, switched sources.list however to jaunty to test as well next to hardy, but didn't help either.
 
Old 09-17-2009, 06:22 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
apt-cache search postgres | grep -i server

What package names does it offer?
 
Old 09-18-2009, 07:58 AM   #3
rsciw
Member
 
Registered: Jan 2009
Location: Essex (UK)
Distribution: Home: Debian/Ubuntu, Work: Ubuntu
Posts: 206

Original Poster
Rep: Reputation: 44
sudo apt-cache search postgres | grep -i server
Code:
aolserver4-nspostgres - AOLserver 4 module: Postgres connector
jabberd2-ldap-pgsql - Jabber Open Source Instant Messenger Server (LDAP & PostgreSQL)
jabberd2-pgsql - Jabber Open Source Instant Messenger Server (PostgreSQL)
libdbd-pg-perl - Perl DBI driver for the PostgreSQL database server
libdbd-pgsql - PostgreSQL database server driver for libdbi
nanoweb - HTTP server written in PHP
papercut - simple and extensible NNTP server
perdition - POP3 and IMAP4 Proxy server
pgpool - connection pool server for PostgreSQL
pgpool2 - connection pool server and replication proxy for PostgreSQL
postgresql-8.2 - object-relational SQL database, version 8.2 server
postgresql-server-dev-8.2 - development files for PostgreSQL 8.2 server-side programming
pure-ftpd-postgresql - Pure-FTPd FTP server with PostgreSQL user authentication
postgresql-8.3 - object-relational SQL database, version 8.3 server
postgresql-server-dev-8.3 - development files for PostgreSQL 8.3 server-side programming
zabbix-server-pgsql - software for monitoring of your networks -- server
freeradius-postgresql - PostgreSQL module for FreeRADIUS server
courier-webadmin - Courier mail server - web-based administration frontend
running apt-get install postgresql-8.3 and 8.2 gave same problems as just "postgresql"
 
Old 09-18-2009, 02:47 PM   #4
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
Sorry, I'm at loss ... I suggest you report your own
thread and ask a mod of this forum to move it to the
Ubuntu distro forum. This seems to be very much a
problem with your repositories and/or the package
management system, not with postgres.


Cheers,
Tink
 
Old 09-20-2009, 08:33 AM   #5
GrapefruiTgirl
LQ Guru
 
Registered: Dec 2006
Location: underground
Distribution: Slackware64
Posts: 7,594

Rep: Reputation: 556Reputation: 556Reputation: 556Reputation: 556Reputation: 556Reputation: 556
Per the OP's request, this thread has been moved to 'Ubuntu' in the hopes that it gets better exposure.

Sasha
 
  


Reply



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
[SOLVED] problems installing postgresql-8.4 using synaptic mrj Debian 5 08-27-2009 01:14 PM
Problems with PostgreSQL 8.3 on Ubuntu Server 8.04. mrotsliah Linux - Software 1 08-16-2009 09:09 PM
Postgresql Setting Problems in ubuntu 5.04 luisben Ubuntu 1 05-09-2008 03:18 AM
LXer: Database Server With postgresql and pgadmin3 in Ubuntu LXer Syndicated Linux News 0 04-20-2008 01:50 PM
Problems installing PostgresQL on Debian 2.12 Testing LDMohican Linux - Software 8 03-07-2006 12:26 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Ubuntu

All times are GMT -5. The time now is 11:12 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