| View previous topic :: View next topic |
| Author |
Message |
Thiemo
Tux's lil' helper
Joined: 20 Nov 2002
Posts: 138
|
 Posted: Thu Nov 06, 2008 9:43 pm Post subject: [solved] Postgresql: init script fails to start pg_ctl howev |
 |
|
Hi all,
I installed PostgreSQL 8.3.4 by emerge. Previously, I remove a 8..0 emerge installation including data directory - just to make sure that the installation was pretty virgin. I didn't know that 8.3 would end up in a completly seperate set of directories. Howerver, I tried to start it with
| Code: | root @ puselheim /etc/apache2/vhosts.d :-( # /etc/init.d/postgresql-8.3 start 08-11-06 20:30
* Caching service dependencies ... [ ok ]
* Starting PostgreSQL ...
waiting for server to start...............................................................could not start ser [ !! ]
* The pid-file doesn't exist but pg_ctl reported a running server.
* Please check whether there is another server running on the same port or read the log-file. [ !! ] |
I tried to confirm with
| Code: | root @ puselheim /etc/apache2/vhosts.d :-( # /etc/init.d/postgresql-8.3 status 08-11-06 20:31
* status: stopped
root @ puselheim /var/lib # nmap -r localhost 08-11-06 21:27
Starting Nmap 4.76 ( http://nmap.org ) at 2008-11-06 21:27 CET
Interesting ports on localhost (127.0.0.1):
Not shown: 994 closed ports
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
143/tcp open imap
993/tcp open imaps
3306/tcp open mysql
10025/tcp open unknown
Nmap done: 1 IP address (1 host up) scanned in 0.34 seconds
|
I also grepped ps for post but no suspicious found.
Actually the same error I had with 8.0 which made me think that my PG installation was somehow borked and I started from scratch.
Funny thing is, that if starting it directly, i.e. not by init script, it starts
| Code: | postgres@puselheim ~ $ /usr/lib/postgresql-8.3/bin/pg_ctl -D /var/lib/postgresql/8.3/data start
server starting
postgres@puselheim ~ $ LOG: database system was shut down at 2008-11-06 20:45:12 CET
LOG: autovacuum launcher started
LOG: database system is ready to accept connections
postgres@puselheim ~ $ ps -ef | grep postgres
postgres 28866 1 2 22:02 pts/2 00:00:00 /usr/lib/postgresql-8.3/bin/postgres -D /var/lib/postgresql/8.3/data
postgres 28868 28866 0 22:02 ? 00:00:00 postgres: writer process
postgres 28869 28866 0 22:02 ? 00:00:00 postgres: wal writer process
postgres 28870 28866 0 22:02 ? 00:00:00 postgres: autovacuum launcher process
postgres 28871 28866 0 22:02 ? 00:00:00 postgres: stats collector process
root @ puselheim /var/lib # nmap -r localhost 08-11-06 21:27
Starting Nmap 4.76 ( http://nmap.org ) at 2008-11-06 22:07 CET
Interesting ports on localhost (127.0.0.1):
Not shown: 993 closed ports
PORT STATE SERVICE
22/tcp open ssh
25/tcp open smtp
143/tcp open imap
993/tcp open imaps
3306/tcp open mysql
5432/tcp open postgresql
10025/tcp open unknown
Nmap done: 1 IP address (1 host up) scanned in 0.29 seconds
postgres@puselheim ~ $ psql -h localhost -d template1
Welcome to psql 8.3.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
template1=# |
I could find no bug related to this. Does somebody knowanything about this issue?
Well, going to read the init script.
Cheers
Thiemo
For completeness find
| Code: | emerge --info postgresql-server
Portage 2.1.4.5 (default-linux/x86/2007.0, gcc-3.4.6, glibc-2.6.1-r0, 2.6.16.37-domU-v1 i686)
=================================================================
System Settings
=================================================================
System uname: 2.6.16.37-domU-v1 i686 Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Timestamp of tree: Thu, 06 Nov 2008 01:17:01 +0000
app-shells/bash: 3.2_p33
dev-java/java-config: 1.3.7, 2.1.6
dev-lang/python: 2.4.4-r13, 2.5.2-r7
dev-python/pycrypto: 2.0.1-r6
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox: 1.2.18.1-r2
sys-devel/autoconf: 2.13, 2.61-r2
sys-devel/automake: 1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10.1-r1
sys-devel/binutils: 2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool: 1.5.26
virtual/os-headers: 2.6.23-r3
ACCEPT_KEYWORDS="x86"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=i686 -fomit-frame-pointer"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/eselect/postgresql /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-O2 -march=i686 -fomit-frame-pointer"
DISTDIR="/usr/portage/distfiles"
FEATURES="ccache collision-protect distlocks metadata-transfer parallel-fetch sandbox sfperms strict unmerge-orphansuserfetch"
GENTOO_MIRRORS="http://mirrors.sec.informatik.tu-darmstadt.de/gentoo/ ftp://pandemonium.tiscali.de/pub/gentoo/ http://mirror.ovh.net/gentoo-distfiles/ http://gentoo.mirror.web4u.cz/ http://mirror.muntinternet.net/pub/gentoo/"
MAKEOPTS="-j5"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="acl afs apache2 berkdb bzip2 cgi cjk clamav cli cracklib crypt cups dri exif fastcgi flac fortran gd gdbm gif gmp gnutls gpm hardened iconv idn imagemagick imap innodb ipv6 isdnlog java java6 javascript jbig jpeg jpeg2k kerberoskolab krb4 latex lcms ldap libwww maildir midi milter mmx mng mudflap mysql mysqli ncurses nis nls nntp nptl nptlonly ofx openmp pam pcre pdf perl php png posix postgres pppd prelude python raw readline reflection rss ruby samba saslsdl session sharedext sharedmem simplexml slang snmp soap sockets spell spl sqlite sqlite3 sse sse2 ssl subversion svg svga tcl tcpd tetex threads tidy tiff tokenizer truetype unicode vhosts vim-syntax vnc wmf x86 xface xinetd xml xmlrpc xorg xpm xsl zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1 emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i740 i810 imstt intel mach64 mga neomagic nsc nv r128 radeon rendition s3 s3virge savage siliconmotionsis sisusb tdfx tga trident tseng v4l vesa vga via vmware voodoo"
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
=================================================================
Package Settings
=================================================================
>>> Attempting to run pkg_info() for 'dev-db/postgresql-server-8.3.4'
Adjusting permissions recursively: '/tmp/tmpzy-s0W/ccache'
* pkg_info() is not defined: 'postgresql-server-8.3.4.ebuild' |
_________________
root ist die wurzel allen uebels
Last edited by Thiemo on Thu Nov 06, 2008 10:36 pm; edited 1 time in total |
|
| Back to top |
|
 |
Thiemo
Tux's lil' helper
Joined: 20 Nov 2002
Posts: 138
|
| Posted: Thu Nov 06, 2008 10:29 pm Post subject: |
|
|
News
I figured out that I was trying to start postgresql with ssl enabled (-l option), but did not prepare the server.cert and server.key file. Now, I only have to figure out where they have to reside... 
_________________
root ist die wurzel allen uebels |
|
| Back to top |
|
|
Thiemo
Tux's lil' helper
Joined: 20 Nov 2002
Posts: 138
|
| Posted: Thu Nov 06, 2008 10:35 pm Post subject: [solved] Postgresql: init script fails to start pg_ctl ... |
|
|
I put the files into the data directory and after I corrected its name server.crt not server.cert  , it works like a charm! 
Still I think the error message is rather missleading.
_________________
root ist die wurzel allen uebels |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
