unable to start PostgreSQL service on suse linux SP4 10

sandeep002gupta · 07-15-2014, 10:48 AM

Hi,

we are getting error when try to start postgresql service.

linux-251:/usr/sbin # /etc/init.d/postgresql start
Starting PostgreSQLcould not start postmaster
failed

while package is installed:
linux-251:~ # rpm -qa |grep postgres*
postgresql-server-8.1.22-0.4.1
postgresql-libs-8.1.22-0.4.1
postgresql-8.1.22-0.4.1
libgda-postgres-1.3.91-32.2

tronayne · 07-15-2014, 11:47 AM

That looks like you need to install postmaster.

Hope this helps some.

TB0ne · 07-15-2014, 12:13 PM

Quote:

Originally Posted by sandeep002gupta

Hi,
we are getting error when try to start postgresql service.

linux-251:/usr/sbin # /etc/init.d/postgresql start
Starting PostgreSQL could not start postmaster failed

while package is installed:
linux-251:~ # rpm -qa |grep postgres*
postgresql-server-8.1.22-0.4.1
postgresql-libs-8.1.22-0.4.1
postgresql-8.1.22-0.4.1
libgda-postgres-1.3.91-32.2

Again, as with numerous other threads of yours:

You are using a COMMERCIAL, PAY-FOR distribution...have you contacted SuSE tech support?
SLES 10 is OLD...it went end-of-life in 2013, with extended support only available if you PAY, through 2016. Since you posted previously about security issues regarding SSL, the question again is, if you want to be secure, why aren't you upgrading and paying for support?

These are the same things that are suggested to you when you post about Red Hat Enterprise.

Have you checked the log files? Any messages/hints? Has this EVER worked for you? Why are you using such an old version of PostgreSQL, rather than upgrading? The logs will give you information about the message, but chances are it is a permissions issue, a path problem, or an issue with the configuration. You (again) don't provide any details that would let anyone help you.

sandeep002gupta · 07-16-2014, 04:57 AM

TB0ne - this is production server OS & we can't update its. we need only installation of PostgreSQL of this server. after installation of rpm we doesn't start service.

sandeep002gupta · 07-16-2014, 04:59 AM

tronayne - can you help me for postmaster package, please provide the link where we can download. I'm searching its in google & SUSE DVD ISO but can't find.
Thanks

tronayne · 07-16-2014, 09:28 AM

It should be part of PostgreSQL:

Code:

locate postmaster
/usr/man/man1/postmaster.1.gz
/usr/lib64/postgresql/9.3/bin/postmaster
/usr/doc/postgresql-9.3.0/html/app-postmaster.html
/usr/include/postgresql/server/postmaster
/usr/include/postgresql/server/postmaster/bgworker.h
/usr/include/postgresql/server/postmaster/postmaster.h
/usr/include/postgresql/server/postmaster/autovacuum.h
/usr/include/postgresql/server/postmaster/pgarch.h
/usr/include/postgresql/server/postmaster/startup.h
/usr/include/postgresql/server/postmaster/fork_process.h
/usr/include/postgresql/server/postmaster/syslogger.h
/usr/include/postgresql/server/postmaster/walwriter.h
/usr/include/postgresql/server/postmaster/bgwriter.h

Probably want to get the current version of PostgreSQL, eh?

Postmaster is a depreciated alias of Postgres.

By the way, did you initialize PostgreSQL after installation (that would be the pgsql directory where you data bases live)?

Hope this helps some.

TB0ne · 07-16-2014, 10:18 AM

Quote:

Originally Posted by sandeep002gupta

TB0ne - this is production server OS & we can't update its

Sorry, but you CAN upgrade it easily. If you're paying for SLES, there is already an established upgrade procedure that would require only one reboot, which is easily done.

Quote:

we need only installation of PostgreSQL of this server. after installation of rpm we doesn't start service.

...which brings us back to the several questions THAT YOU HAVE STILL NOT ANSWERED, much the same as numerous other threads of yours:

You are using a COMMERCIAL, PAY-FOR distribution...have you contacted SuSE tech support?
SLES 10 is OLD...it went end-of-life in 2013, with extended support only available if you PAY, through 2016. Since you posted previously about security issues regarding SSL, the question again is, if you want to be secure, why aren't you upgrading and paying for support?
These are the same things that are suggested to you when you post about Red Hat Enterprise.
Have you checked the log files? Any messages/hints?
Has this EVER worked for you?
Why are you using such an old version of PostgreSQL, rather than upgrading?

AGAIN, as you've been told several times, unless you provide details and answer questions, there's little we can help you with, and not much point in posting.

sandeep002gupta · 07-16-2014, 11:06 AM

tronayne - thanks for information.

we see the below logs:

postgres@linux-251:~> postmaster -d 5 -D /var/lib/pgsql/data/
2014-07-15 20:58:18 IST DEBUG: postmaster: PostmasterMain: initial environ dump:
2014-07-15 20:58:18 IST DEBUG: -----------------------------------------
2014-07-15 20:58:18 IST DEBUG: LESSKEY=/etc/lesskey.bin
2014-07-15 20:58:18 IST DEBUG: NNTPSERVER=news
2014-07-15 20:58:18 IST DEBUG: INFODIR=/usr/local/info:/usr/share/info:/usr/info
2014-07-15 20:58:18 IST DEBUG: MANPATH=/usr/local/man:/usr/local/share/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/share/man
2014-07-15 20:58:18 IST DEBUG: ORA_CRS_HOME=/opt/oracle/product/10gR2/crs
2014-07-15 20:58:18 IST DEBUG: HOSTNAME=linux-251
2014-07-15 20:58:18 IST DEBUG: GNOME2_PATH=/usr/local:/opt/gnome:/usr
2014-07-15 20:58:18 IST DEBUG: XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
2014-07-15 20:58:18 IST DEBUG: HOST=linux-251
2014-07-15 20:58:18 IST DEBUG: SHELL=/bin/bash
2014-07-15 20:58:18 IST DEBUG: TERM=xterm
2014-07-15 20:58:18 IST DEBUG: PROFILEREAD=true
2014-07-15 20:58:18 IST DEBUG: HISTSIZE=1000
2014-07-15 20:58:18 IST DEBUG: MORE=-sl
2014-07-15 20:58:18 IST DEBUG: ORA_ASM_HOME=/opt/oracle/product/10gR2/asm
2014-07-15 20:58:18 IST DEBUG: GROFF_NO_SGR=yes
2014-07-15 20:58:18 IST DEBUG: USER=postgres
2014-07-15 20:58:18 IST DEBUG: LS_COLORS=no=00:fi=00:di=01;34:ln=00;36

i=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01

r=41;33; 01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tb z=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00 ;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bm p=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=0 1;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35 :*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc =00;32:*.wav=00;32:
2014-07-15 20:58:18 IST DEBUG: ORACLE_SID=orcl
2014-07-15 20:58:18 IST DEBUG: XNLSPATH=/usr/X11R6/lib/X11/nls
2014-07-15 20:58:18 IST DEBUG: ENV=/etc/bash.bashrc
2014-07-15 20:58:18 IST DEBUG: ORACLE_BASE=/opt/oracle
2014-07-15 20:58:18 IST DEBUG: HOSTTYPE=x86_64
2014-07-15 20:58:18 IST DEBUG: FROM_HEADER=
2014-07-15 20:58:18 IST DEBUG: PAGER=less
2014-07-15 20:58:18 IST DEBUG: CSHEDIT=emacs
2014-07-15 20:58:18 IST DEBUG: XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/
2014-07-15 20:58:18 IST DEBUG: MINICOM=-c on
2014-07-15 20:58:18 IST DEBUG: MAIL=/var/spool/mail/postgres
2014-07-15 20:58:18 IST DEBUG: PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin
2014-07-15 20:58:18 IST DEBUG: CPU=x86_64
2014-07-15 20:58:18 IST DEBUG: INPUTRC=/etc/inputrc
2014-07-15 20:58:18 IST DEBUG: PWD=/var/lib/pgsql
2014-07-15 20:58:18 IST DEBUG: LANG=en_US.UTF-8
2014-07-15 20:58:18 IST DEBUG: PYTHONSTARTUP=/etc/pythonstart
2014-07-15 20:58:18 IST DEBUG: TEXINPUTS=:/var/lib/pgsql/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
2014-07-15 20:58:18 IST DEBUG: QT_SYSTEM_DIR=/usr/share/desktop-data
2014-07-15 20:58:18 IST DEBUG: SHLVL=1
2014-07-15 20:58:18 IST DEBUG: HOME=/var/lib/pgsql
2014-07-15 20:58:18 IST DEBUG: LESS_ADVANCED_PREPROCESSOR=no
2014-07-15 20:58:18 IST DEBUG: OSTYPE=linux
2014-07-15 20:58:18 IST DEBUG: LS_OPTIONS=-N --color=tty -T 0
2014-07-15 20:58:18 IST DEBUG: XCURSOR_THEME=Industrial
2014-07-15 20:58:18 IST DEBUG: WINDOWMANAGER=/usr/X11R6/bin/gnome
2014-07-15 20:58:18 IST DEBUG: GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0
2014-07-15 20:58:18 IST DEBUG: G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252
2014-07-15 20:58:18 IST DEBUG: LESS=-M -I
2014-07-15 20:58:18 IST DEBUG: MACHTYPE=x86_64-suse-linux
2014-07-15 20:58:18 IST DEBUG: LOGNAME=postgres
2014-07-15 20:58:18 IST DEBUG: GTK_PATH64=/usr/local/lib64/gtk-2.0:/opt/gnome/lib64/gtk-2.0:/usr/lib64/gtk-2.0
2014-07-15 20:58:18 IST DEBUG: CVS_RSH=ssh
2014-07-15 20:58:18 IST DEBUG: XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share/:/opt/gnome/share/
2014-07-15 20:58:18 IST DEBUG: ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal
2014-07-15 20:58:18 IST DEBUG: PGDATA=/var/lib/pgsql/data
2014-07-15 20:58:18 IST DEBUG: PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/local/share/pkgconfig:/usr/lib64/pkgconfig:/usr/share/pkgconfig:/opt/kde3/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/lib64/pkgconfig:/opt/gnome/share/pkgconfig
2014-07-15 20:58:18 IST DEBUG: LESSOPEN=lessopen.sh %s
2014-07-15 20:58:18 IST DEBUG: INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
2014-07-15 20:58:18 IST DEBUG: ORACLE_HOME=/opt/oracle/product/10.2/db_1
2014-07-15 20:58:18 IST DEBUG: LESSCLOSE=lessclose.sh %s %s
2014-07-15 20:58:18 IST DEBUG: G_BROKEN_FILENAMES=1
2014-07-15 20:58:18 IST DEBUG: COLORTERM=1
2014-07-15 20:58:18 IST DEBUG: _=/usr/bin/postmaster
2014-07-15 20:58:18 IST DEBUG: PGLOCALEDIR=/usr/share/locale
2014-07-15 20:58:18 IST DEBUG: PGSYSCONFDIR=/usr/etc/postgresql
2014-07-15 20:58:18 IST DEBUG: LC_COLLATE=en_US.UTF-8
2014-07-15 20:58:18 IST DEBUG: LC_MESSAGES=en_US.UTF-8
2014-07-15 20:58:18 IST DEBUG: LC_MONETARY=C
2014-07-15 20:58:18 IST DEBUG: LC_NUMERIC=C
2014-07-15 20:58:18 IST DEBUG: LC_TIME=C
2014-07-15 20:58:18 IST DEBUG: -----------------------------------------
postgres@linux-251:~> ps -ef | grep postmaster
postgres 5922 5807 0 21:02 pts/2 00:00:00 grep postmast

but on another production we've check its show OK :-
agilis@lxapp8018:~> rpm -qa |grep post
postfix-2.5.6-4.12.1
postgresql-8.1.23-0.11.1
postgresql-server-8.1.23-0.11.1
postgresql-libs-8.1.23-0.11.1
agilis@lxapp8018:~> ps -ef | grep post
postgres 9594 22810 0 Jul16 ? 00:00:00 postgres: postgres vbase 10.118.237.6(47982) idle
postgres 9960 22810 1 Jul15 ? 00:32:06 postgres: postgres vbase 10.118.237.6(54231) idle
postgres 10394 22810 0 Jul16 ? 00:00:00 postgres: postgres vbase 10.118.237.6(38676) idle
postgres 10395 22810 0 Jul16 ? 00:00:00 postgres: postgres vbase 10.118.237.6(38677) idle
agilis 13569 13491 0 01:28 pts/1 00:00:00 grep post
postgres 22810 1 0 May31 ? 00:00:00 /usr/bin/postmaster -D /var/lib/pgsql/data
postgres 22811 22810 0 May31 ? 00:00:00 postgres: logger process
postgres 22813 22810 0 May31 ? 00:00:03 postgres: writer process
postgres 22814 22810 0 May31 ? 00:00:00 postgres: stats buffer process
postgres 22815 22814 0 May31 ? 00:00:00 postgres: stats collector process
postgres 25552 22810 2 Jul16 ? 00:24:44 postgres: postgres vbase 10.118.237.6(56304) idle
postgres 31866 22810 1 Jul16 ? 00:09:44 postgres: postgres vbase 10.118.237.6(46066) idle
postgres 32541 22810 0 Jul03 ? 00:00:00 postgres: postgres vbase 10.118.237.6(59287) idle

sandeep002gupta · 07-16-2014, 11:23 AM

let me know if have any link to download PostgreSQL-8.1.23-0.11.1 package with step for installation on suse 10.

TB0ne -

Originally Posted by TB0ne
Sorry, but you CAN upgrade it easily. If you're paying for SLES, there is already an established upgrade procedure that would require only one reboot, which is easily done.

- yes we can upgrade OS easily but on production server client is not permitted due to no. of process & compatibility required for go through chain.

- we've some logs send in earlier may be it will be helpful.

TB0ne · 07-16-2014, 01:58 PM

Quote:

Originally Posted by sandeep002gupta

let me know if have any link to download PostgreSQL-8.1.23-0.11.1 package with step for installation on suse 10.

AGAIN, since you aren't paying attention: SLES 10sp4 is a COMMERCIAL, PAY FOR PRODUCT...if you want packages for it, you need to be PAYING FOR SLES, at which point you can download them through their software repositories. This is the same thing you've been told several times now, both for SLES and RHEL. The answer remains the same. The "step for installation" is"

Contact SuSE support
Install the latest version of things via the online repositories
-OR- Get the source package from support and ask them for installation instructions

Quote:

- yes we can upgrade OS easily but on production server client is not permitted due to no. of process & compatibility required for go through chain.

So you say that you CAN upgrade, but won't because it's too much effort to "go through chain"?? If you are the client, then you need to stop what you're doing, and give your systems administrators the job of fixing the broken postgresql. If you ARE the administrator, then there is NO REASON you cannot upgrade. The "number of processes" is meaningless...either you want a secure, up-to-date server or not.

Quote:

- we've some logs send in earlier may be it will be helpful.

It would be helpful if you ANSWERED THE QUESTIONS you've been asked several times now, including the one asked by tronayne . You didn't post ANY log information at all, just the output of the postmaster command, which is NOT a log file.