Skip site navigation (1) Skip section navigation (2)

upgrade problem

From: Thomas Keller <kellert(at)ohsu(dot)edu>
To: Postgresql PDX_Users <pdxpug(at)postgresql(dot)org>
Subject: upgrade problem
Date: 2008-02-29 22:59:45
Message-ID: C6DAA3DA-1BEB-4CD6-B4BE-6021F5B3582F@ohsu.edu (view raw or flat)
Thread:
Lists: pdxpug
Hi,
Darn, I thought I had this under control.
I just installed 8.3.0 and it seemed to go OK.

The server seems to be running OK:
> $ sudo -u postgres pg_ctl restart
> pg_ctl: PID file "/usr/local/pgsql/data/postmaster.pid" does not exist
> Is server running?
> starting server anyway
> pg_ctl: could not read file "/usr/local/pgsql/data/postmaster.opts"


But now, trying to create a database I get an error:

> $ createdb testdb
> createdb: could not connect to database postgres: could not connect  
> to server: No such file or directory
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?


Here's my $PGDATA:
> $ sudo -u postgres ls -al $PGDATA
> total 32
> drwx------ 14 postgres wheel   476 Feb 28 17:21 .
> drwxr-xr-x  9 root     wheel   306 Feb 28 17:19 ..
> -rw-------  1 postgres wheel     4 Feb 28 17:20 PG_VERSION
> drwx------  5 postgres wheel   170 Feb 28 17:21 base
> drwx------ 30 postgres wheel  1020 Feb 28 17:21 global
> drwx------  3 postgres wheel   102 Feb 28 17:21 pg_clog
> -rw-------  1 postgres wheel  3429 Feb 28 17:21 pg_hba.conf
> -rw-------  1 postgres wheel  1460 Feb 28 17:21 pg_ident.conf
> drwx------  4 postgres wheel   136 Feb 28 17:20 pg_multixact
> drwx------  3 postgres wheel   102 Feb 28 17:21 pg_subtrans
> drwx------  2 postgres wheel    68 Feb 28 17:20 pg_tblspc
> drwx------  2 postgres wheel    68 Feb 28 17:20 pg_twophase
> drwx------  4 postgres wheel   136 Feb 28 17:21 pg_xlog
> -rw-------  1 postgres wheel 16552 Feb 28 17:21 postgresql.conf


And here's my config:
> BINDIR = /usr/local/pgsql/bin
> DOCDIR = /usr/local/pgsql/doc
> INCLUDEDIR = /usr/local/pgsql/include
> PKGINCLUDEDIR = /usr/local/pgsql/include
> INCLUDEDIR-SERVER = /usr/local/pgsql/include/server
> LIBDIR = /usr/local/pgsql/lib
> PKGLIBDIR = /usr/local/pgsql/lib
> LOCALEDIR =
> MANDIR = /usr/local/pgsql/man
> SHAREDIR = /usr/local/pgsql/share
> SYSCONFDIR = /usr/local/pgsql/etc
> PGXS = /usr/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk
> CONFIGURE = '--with-includes=/sw/include:/opt/local/include' '-- 
> with-libraries=/sw/lib:/opt/local/lib' '--with-perl' '--with-krb5'  
> '--with-openssl' '--with-pam' '--with-ldap' '--with-bonjour' '-- 
> with-libxml'
> CC = gcc -no-cpp-precomp
> CPPFLAGS = -I/sw/include/libxml2 -I/sw/include -I/sw/include -I/opt/ 
> local/include
> CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline - 
> Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
> CFLAGS_SL =
> LDFLAGS = -L/sw/lib -L/sw/lib -L/sw/lib -L/opt/local/lib
> LDFLAGS_SL =
> LIBS = -lpgport -lxml2 -lpam -lssl -lcrypto -lkrb5 -lz -lreadline -lm
> VERSION = PostgreSQL 8.3.0


Hopefully, it is something simple. Help, please.
Tom Keller
MMI Shared Resource Facility
503-494-2442
kellert at ohsu.edu



pdxpug by date

Next:From: Thomas KellerDate: 2008-03-01 21:08:42
Subject: TCP/IP connection
Previous:From: Kirsten ComandichDate: 2008-02-29 22:28:41
Subject: Re: [Code 'n' Splode] Mtg Recap: Extreme DB Makeover: RT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group