https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c1 Bruno Friedmann changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO CC| |bruno@ioda-net.ch InfoProvider| |john4deidre@clear.net.nz --- Comment #1 from Bruno Friedmann 2013-01-19 13:19:42 UTC --- Please copy & paste the content of /var/lib/pgsql/initlog and /var/lib/pgsql/data/postmaster.log also normally you should have a line with # TYPE DATABASE USER ADDRESS METHOD local all postgres trust in pg_hba.conf To be sure of what is causing the trouble you see, re-enable the comment on postgres.conf and retry. Also check system log for any supplemental message about postgres -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c3 --- Comment #3 from John Shand 2013-01-20 03:40:17 UTC --- i also attempted the same steps with firebird and mysql. i got the same result as i got with postgresql. the error read 'postgresql: Failed Service'. the same follows with firebird or mysql. there is a possibility that the bug maybe with the runlevel settings in yast2. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c Thomas Göttlicher changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW InfoProvider|john4deidre@clear.net.nz | AssignedTo|yast2-maintainers@suse.de |mvidner@suse.com -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c6 Josef Reidinger changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jdluhos@suse.com --- Comment #6 from Josef Reidinger 2013-09-27 15:15:10 UTC --- *** Bug 800492 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=800492 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c8 Josef Reidinger changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jstephan@key-systems.net --- Comment #8 from Josef Reidinger 2013-09-27 15:42:52 UTC --- *** Bug 836568 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=836568 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c10 --- Comment #10 from Frederic Crozat 2013-09-27 17:00:13 UTC --- shouldn't we close, since, runlevel has been replaced by service manager ? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c12 Martin Vidner changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jw@suse.com --- Comment #12 from Martin Vidner 2013-10-01 10:26:32 CEST --- *** Bug 801944 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=801944 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c13 Vladimir Moravec changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |CLOSED Resolution| |WONTFIX --- Comment #13 from Vladimir Moravec 2013-10-14 11:58:21 UTC --- yast-runlevel works with SysV, opensuse 13.1 has systemd. There will be no fixes targeting opensuse 13.1 coming for yast-runlevel anymore. It's been replaced with yast-services-manager. As it's the case with postgres or mariadb/mysql, some packages are still missing the service files (see bnc#840159 ) which makes their behaviour with systemd unexpected and buggy. I tested the recent postgresql with opensuse-13.1-beta1 and `systemctl start postgresql` fails. The same is valid for mariadb/mysql. Please ask the postgresql (and others) maintainers for fixing this. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c15 Reinhard Max changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |WONTFIX --- Comment #15 from Reinhard Max 2013-10-15 09:28:58 CEST --- AFAIU systemd got introduced with the promise that it will continnue to support SysV init scripts. Therefore I see no need to convert PostgreSQL to service files. Please file a bug against systemd if support for init scripts is broken there. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c17 Frederic Crozat changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|fcrozat@suse.com |max@suse.com --- Comment #17 from Frederic Crozat 2013-10-15 13:02:50 UTC --- postgresql initscript is playing with "su - postgres" -c "$CMD", which causes pam session to be opened (and closed) in an initscript. This should be avoided at all cost and is not supported. systemd is providing for separate "User / Group" facility for this reason. I suggest to grab Fedora 20 service for postgresql (might need a few adaptation) http://pkgs.fedoraproject.org/cgit/postgresql.git/tree/postgresql.service?h=... You can still ship the initscript, it will be ignored when .service is detected. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c19 --- Comment #19 from Frederic Crozat 2013-10-15 13:44:17 UTC --- This won't happen, sorry. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c21 Ludwig Nussel changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lnussel@suse.com --- Comment #21 from Ludwig Nussel 2013-10-15 16:33:34 CEST --- opening pam sessions is not a security hole but it is inappropriate to do in this case. Using su non-interactively is more or less undefined behavior IMO. Better stay away from it. Even interactively it doesn't fit into todays world anymore. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c23 Bruno Friedmann changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEEDINFO InfoProvider| |max@suse.com --- Comment #23 from Bruno Friedmann 2013-10-29 16:42:44 UTC --- What improvements we can propose to resolve the case. I've quickly review the init script and most of the time, there will be no reason from what I've found to use root then su. If the systemd units are correctly created and indicate postgres as user & group. @Reinhard could you describe in human formal language the attended action the init script has to realize. And possibly certain corner case I certainly missed during my review ? There's around the web some solutions like Arch, certain have been extended to have several instances of pg running so you get pg-id0-n etc. I don't think we could easily emulate the perfect way of running pg cluster as debian do it, but I'm confident we can replace the init script. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c25 --- Comment #25 from Bruno Friedmann 2013-10-31 18:42:10 UTC --- systemctl status postgresql.service postgresql.service - PostgreSQL database server Loaded: loaded (/etc/systemd/system/postgresql.service; enabled) Active: active (running) since Thu, 2013-10-31 19:13:24 CET; 13min ago Process: 24344 ExecStop=/usr/bin/pg_ctl stop -D ${PGDATA} -s -m fast (code=exited, status=0/SUCCESS) Process: 32606 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS) Main PID: 32609 (postgres) CGroup: name=systemd:/system/postgresql.service ├ 32609 /usr/lib/postgresql92/bin/postgres -D /var/lib/pgsql/data -p 5432 ├ 32610 postgres: logger process ├ 32612 postgres: checkpointer process ├ 32613 postgres: writer process ├ 32614 postgres: wal writer process ├ 32615 postgres: autovacuum launcher process └ 32616 postgres: stats collector process Oct 31 19:13:23 c-3po.labaroche.ioda.net systemd[1]: Starting PostgreSQL database server... Oct 31 19:13:23 c-3po.labaroche.ioda.net postgres[32611]: [1-1] 2013-10-31 19:13:23 CET LOG: database system was shut down at 2013-10-31 19:03:50 CET Oct 31 19:13:23 c-3po.labaroche.ioda.net postgres[32609]: [1-1] 2013-10-31 19:13:23 CET LOG: database system is ready to accept connections Oct 31 19:13:23 c-3po.labaroche.ioda.net postgres[32615]: [1-1] 2013-10-31 19:13:23 CET LOG: autovacuum launcher started Oct 31 19:13:24 c-3po.labaroche.ioda.net systemd[1]: Started PostgreSQL The work is higly inspired from what Devrin do for postgresql http://svn.pgrpms.org/browser/rpm/redhat/9.3/postgresql/F-19/postgresql-9.3s... -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c27 Reinhard Max changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |REOPENED InfoProvider|max@suse.com | --- Comment #27 from Reinhard Max 2013-11-04 12:14:26 CET --- Thanks guys for your effort, but I am determined to stick with sysv scripts for the PostgreSQL server as per systemd's promise to keep supporting them. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c29 Reinhard Max changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEEDINFO InfoProvider| |fcrozat@suse.com --- Comment #29 from Reinhard Max 2013-11-04 14:30:25 CET ---

There won't be any change on systemd side, as explained in comments 17 and 21.

Well, especially comment 17 is exactly not explaininig anything. It only states that something "should be avoided at all costs", but fails to tell why. As PostgreSQL's use of su in the init script was there for more than 10 years without any problems and/or complaints, I want some stronger prove of why it all of a sudden is not a good idea anymore, especially as sysv init script compatibility is stated so prominently on the systemd home page. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c31 Reinhard Max changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Component|Other |Other Version|13.1 Beta 1 |Final Resolution| |WORKSFORME AssignedTo|max@suse.com |bnc-team-screening@forge.pr | |ovo.novell.com Product|openSUSE Factory |openSUSE 13.1 Target Milestone|--- |Final --- Comment #31 from Reinhard Max 2013-11-22 18:52:10 CET --- I meanwhile upgraded to 13.1 GA and found that PostgreSQL starts just fine from the init script at boot time and when calling it from the command line. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c33 Scott Easterday changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |scott.easterday@tigoenergy. | |com --- Comment #33 from Scott Easterday 2013-12-20 17:14:28 UTC --- Is there an ETA on when the startup script will be available. I am using the Unofficial one now but prefer the correct one that works with sysconfig as well. FYI: Not having a LAMP server with Pgsql working out of the box does not look good for openSuse or Postgres. Please make higher priority. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c35 --- Comment #35 from Scott Easterday 2013-12-20 19:01:58 UTC --- Awww I see chkconfig enables it and probably the better way to do it. I have always used the Yast-Runlevels to enable it and when it was gone, I was confused at what happened. There is already a forum post on this http://forums.opensuse.org/english/get-technical-help-here/applications/4924... Still be good to decrease confusion soon. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.