[Bug 799471] New: postgresql: issues with using postgresql 9.2.2.
https://bugzilla.novell.com/show_bug.cgi?id=799471 https://bugzilla.novell.com/show_bug.cgi?id=799471#c0 Summary: postgresql: issues with using postgresql 9.2.2. Classification: openSUSE Product: openSUSE Factory Version: 12.3 Beta 1 Platform: x86-64 OS/Version: SUSE Other Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: john4deidre@clear.net.nz QAContact: qa-bugs@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:18.0) Gecko/20100101 Firefox/18.0 in the pg_hba.conf i made the following changes: 1. with host i changed both uncommented host all all ident (to md5) ipv4 and i did the same with the ipv6 as well. in the postgres.conf i made the following changes: 1. uncommented the port=5432 i have tried to set postgresql to start at start up and it won't do so giving an error of 'postgresql: failed to start service' or something similar to this. Reproducible: Always Steps to Reproduce: 1. install postgresql with server as well 2. use the settings i have provided 3. try and run runlevel and try to start postgresql as a service and save your changes. Actual Results: does not start service Expected Results: to start the service and save so it will run each time on start up. -- 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#c1 Bruno Friedmann <bruno@ioda-net.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO CC| |bruno@ioda-net.ch InfoProvider| |john4deidre@clear.net.nz --- Comment #1 from Bruno Friedmann <bruno@ioda-net.ch> 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#c2 --- Comment #2 from John Shand <john4deidre@clear.net.nz> 2013-01-20 00:13:14 UTC --- The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". initlog: fixing permissions on existing directory /var/lib/pgsql/data ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 24MB creating configuration files ... ok creating template1 database in /var/lib/pgsql/data/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating collations ... ok creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... ok loading PL/pgSQL server-side language ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok Success. You can now start the database server using: /usr/bin/postgres -D /var/lib/pgsql/data or /usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start postmaster.log file is empty -- 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 <john4deidre@clear.net.nz> 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#c4 Andreas Jaeger <aj@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|bnc-team-screening@forge.pr |yast2-maintainers@suse.de |ovo.novell.com | --- Comment #4 from Andreas Jaeger <aj@suse.com> 2013-02-25 15:42:06 UTC --- runlevel settings in yast2 -> YaST maintainers -- 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 <tgoettlicher@suse.com> 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#c5 Josef Reidinger <jreidinger@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jreidinger@suse.com AssignedTo|mvidner@suse.com |locilka@suse.com Summary|postgresql: issues with |yast2-runlevel does not |using postgresql 9.2.2. |work well with systemd --- Comment #5 from Josef Reidinger <jreidinger@suse.com> 2013-09-27 15:14:17 UTC --- OK, make this one generic one that runlevel doesn't play well with systemd as there is bunch of duplicates of it. -- 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 <jreidinger@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jdluhos@suse.com --- Comment #6 from Josef Reidinger <jreidinger@suse.com> 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#c7 Josef Reidinger <jreidinger@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rommel@suse.com --- Comment #7 from Josef Reidinger <jreidinger@suse.com> 2013-09-27 15:34:38 UTC --- *** Bug 808317 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=808317 -- 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 <jreidinger@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jstephan@key-systems.net --- Comment #8 from Josef Reidinger <jreidinger@suse.com> 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#c9 Josef Reidinger <jreidinger@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kiv@mail.orbitel.bg --- Comment #9 from Josef Reidinger <jreidinger@suse.com> 2013-09-27 15:46:24 UTC --- *** Bug 840798 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=840798 -- 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 <fcrozat@suse.com> 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#c11 --- Comment #11 from Josef Reidinger <jreidinger@suse.com> 2013-09-30 05:19:21 UTC --- (In reply to comment #10)
shouldn't we close, since, runlevel has been replaced by service manager ?
well, I don't know what is current state of services manager, so I let it decide maintainer of such module. -- 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 <mvidner@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jw@suse.com --- Comment #12 from Martin Vidner <mvidner@suse.com> 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#c Lukas Ocilka <locilka@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |locilka@suse.com AssignedTo|locilka@suse.com |vmoravec@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#c13 Vladimir Moravec <vmoravec@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |CLOSED Resolution| |WONTFIX --- Comment #13 from Vladimir Moravec <vmoravec@suse.com> 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#c14 Vladimir Moravec <vmoravec@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CLOSED |REOPENED Resolution|WONTFIX | AssignedTo|vmoravec@suse.com |max@suse.com Summary|yast2-runlevel does not |Postgresql does not start |work well with systemd | --- Comment #14 from Vladimir Moravec <vmoravec@suse.com> 2013-10-14 13:47:33 UTC --- Reopening and changing assagniment to postgresql team. -- 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 <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |WONTFIX --- Comment #15 from Reinhard Max <max@suse.com> 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#c16 Lukas Ocilka <locilka@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WONTFIX | AssignedTo|max@suse.com |fcrozat@suse.com --- Comment #16 from Lukas Ocilka <locilka@suse.com> 2013-10-15 12:31:54 UTC --- Reopening and reassigning: According to previous comments, systemd is expected to be working with the current SysV init files and thus systemctl (see comment #13) is expected to work as well. Yast Services Manager (as well as Yast Runlevel) start services with systemctl. -- 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 <fcrozat@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|fcrozat@suse.com |max@suse.com --- Comment #17 from Frederic Crozat <fcrozat@suse.com> 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#c18 Reinhard Max <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|max@suse.com |fcrozat@suse.com --- Comment #18 from Reinhard Max <max@suse.com> 2013-10-15 15:33:02 CEST --- (In reply to comment #17)
I suggest to grab Fedora 20 service for postgresql (might need a few adaptation)
No, thanks. Please fix systemd to fulfil its promise. -- 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 <fcrozat@suse.com> 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#c20 Jos Poortvliet <jpoortvliet@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jpoortvliet@suse.com --- Comment #20 from Jos Poortvliet <jpoortvliet@suse.com> 2013-10-15 13:54:20 UTC --- @Reinhard From what I understand, opening pam sessions is a security problem. This has been fixed: you can't do that anymore. Now postgresql doesn't work because it depended that security hole. Are you seriously asking to re-open the security hole because you don't want to fix the init script? If you don't want to go for a systemd service file, fine. Fix the init script to be secure (not open a PAM session) and things will work. -- 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 <lnussel@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lnussel@suse.com --- Comment #21 from Ludwig Nussel <lnussel@suse.com> 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#c22 Reinhard Max <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |erik@apption.com --- Comment #22 from Reinhard Max <max@suse.com> 2013-10-24 10:21:17 CEST --- *** Bug 847333 has been marked as a duplicate of this bug. *** http://bugzilla.novell.com/show_bug.cgi?id=847333 -- 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 <bruno@ioda-net.ch> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEEDINFO InfoProvider| |max@suse.com --- Comment #23 from Bruno Friedmann <bruno@ioda-net.ch> 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#c24 --- Comment #24 from Bruno Friedmann <bruno@ioda-net.ch> 2013-10-31 18:26:52 UTC --- Created an attachment (id=565779) --> (http://bugzilla.novell.com/attachment.cgi?id=565779) Systemd service file for starting postgresql Here's a proposal to fix the situation. This file is working great even under 12.3 There's the missing par for checking if the db data initdb has to be done. @fcrozat any good idea ? I was thinking about a prestart line. Or like apache2 make a wrapper script which do the precheck & initdb if needed ? -- 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 <bruno@ioda-net.ch> 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#c26 --- Comment #26 from Frederic Crozat <fcrozat@suse.com> 2013-11-04 10:51:15 UTC --- (In reply to comment #24)
Created an attachment (id=565779) --> (http://bugzilla.novell.com/attachment.cgi?id=565779) [details] Systemd service file for starting postgresql
Here's a proposal to fix the situation. This file is working great even under 12.3
There's the missing par for checking if the db data initdb has to be done. @fcrozat any good idea ? I was thinking about a prestart line.
Or like apache2 make a wrapper script which do the precheck & initdb if needed ?
My advise would be to use a single ExecStartPre line if it is not too long but if the check is a bit complex and requires shell code, better to move it to a separate script file and call it in ExecStartPre. -- 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 <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |REOPENED InfoProvider|max@suse.com | --- Comment #27 from Reinhard Max <max@suse.com> 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#c28 Frederic Crozat <fcrozat@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|fcrozat@suse.com |max@suse.com --- Comment #28 from Frederic Crozat <fcrozat@suse.com> 2013-11-04 12:12:56 UTC --- reassigning to postgresql maintainer. There won't be any change on systemd side, as explained in comments 17 and 21. -- 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 <max@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEEDINFO InfoProvider| |fcrozat@suse.com --- Comment #29 from Reinhard Max <max@suse.com> 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#c30 Frederic Crozat <fcrozat@suse.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |REOPENED CC| |fcrozat@suse.com InfoProvider|fcrozat@suse.com | --- Comment #30 from Frederic Crozat <fcrozat@suse.com> 2013-11-04 13:40:44 UTC --- I won't repeat what ludwig explained in comment 21, since he knows better than me "su" and the authentication framework.. -- 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 <max@suse.com> 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 <max@suse.com> 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#c32 --- Comment #32 from Bruno Friedmann <bruno@ioda-net.ch> 2013-11-22 20:15:08 UTC --- I found it working too on 13.1 But @Reinhard couldn't we have a kind of talking together with Fedora/Redhat and other user of systemd + postgresql upstream people to find a consensus around how to start/manage/migrate postgresql the best way, And finally make administrators life easy in any environment. I would say that Fosdem, or event the postgresql day before fosdem could be a perfect place to start discussing about it ? What's your opinion on it? -- 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 <scott.easterday@tigoenergy.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |scott.easterday@tigoenergy. | |com --- Comment #33 from Scott Easterday <scott.easterday@tigoenergy.com> 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#c34 --- Comment #34 from Bruno Friedmann <bruno@ioda-net.ch> 2013-12-20 18:28:22 UTC --- Created an attachment (id=572781) --> (http://bugzilla.novell.com/attachment.cgi?id=572781) openSUSE 13.1 postgresql install enable and start This is the print screen of a newly openSUSE_13.1 vm with installation of postgresql-server enabling the service see systemctl complain but chkconfig say it's on starting the service connecting the db If you're doesn't start, are you sure you have setup correctly shmax etc ? -- 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 <scott.easterday@tigoenergy.com> 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.
participants (1)
-
bugzilla_noreply＠novell.com