Bug 10807

Summary: postgresql не стартует
Product: Sisyphus Reporter: Artem Zolochevskiy <azol>
Component: postgresql8.0-serverAssignee: Ivan Fedorov <ns>
Status: CLOSED FIXED QA Contact: qa-sisyphus
Severity: major    
Priority: P2 CC: algor, enp, ldv, misha, mithraen, thresh
Version: unstable   
Hardware: all   
OS: Linux   

Description Artem Zolochevskiy 2007-02-08 23:20:39 MSK
# /etc/init.d/postgresql start
Adjusting environment for postgresql:                                                      
[ DONE ]
Creating default database: /bin/su: unrecognized option 
`--pgdata=/var/lib/pgsql-root/var/lib/pgsql/data'
usage: su [-|-l] [-c "command"] [-s "shell"] [username]
                                                                                      
[FAILED]

опечаточка где-то?

[root@alt ~]# rpm -q postgresql8.0-server
postgresql8.0-server-8.0.11-alt1
Comment 1 Ivan Fedorov 2007-02-23 10:44:50 MSK
Денис, проверь, плс.
Comment 2 Artem Zolochevskiy 2007-04-01 00:46:29 MSD
Так а чего тут проверять то?

Бага есть и в 8.0 и в 8.1 и в 8.2 - покажу на примере

# ls -ld /var/lib/p*
ls: /var/lib/p*: No such file or directory
# rpm -qa |grep postgresql
# apt-get install postgresql8.1-server
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
  postgresql-common postgresql8.1
The following NEW packages will be installed:
  postgresql-common postgresql8.1 postgresql8.1-server
0 upgraded, 3 newly installed, 0 removed and 0 not upgraded.
Need to get 0B/5571kB of archives.
After unpacking 14.5MB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Committing changes...
Preparing...                 ####################################### [100%]
1: postgresql8.1             ####################################### [ 33%]
2: postgresql8.1-server      ####################################### [ 66%]
groupadd: group psqluser exists
Done.

# service postgresql start
Adjusting environment for postgresql:                               [ DONE ]
Creating default database: /bin/su: unrecognized option 
`--pgdata=/var/lib/pgsql-root/var/lib/pgsql/data'
usage: su [-|-l] [-c "command"] [-s "shell"] [username]
                                                                    [FAILED]


вот так вот :(
как я понимаю в /etc/init.d/postgresql не отрабатывает

action "Creating default database:" /bin/su -s /bin/sh -l po
stgres -c "/usr/bin/initdb --pgdata=\"$PG_CHROOT_DIR$PGDATA\""
Comment 3 Ivan Fedorov 2007-04-17 20:42:55 MSD
postgresql8.2-server-8.2.3-alt4
Comment 4 Ivan Fedorov 2007-04-17 20:44:31 MSD
*** Bug 11394 has been marked as a duplicate of this bug. ***
Comment 5 Ivan Fedorov 2007-04-17 20:54:47 MSD
*** Bug 11425 has been marked as a duplicate of this bug. ***
Comment 6 Slava Dubrovskiy 2007-05-03 16:22:42 MSD
# /usr/sbin/vzctl exec 105 service postgresql start
Adjusting environment for postgresql: [ DONE ]
Creating default database: /bin/su: unrecognized option
`--pgdata=/var/lib/pgsql-root/var/lib/pgsql/data'
usage: su [-|-l] [-c "command"] [-s "shell"] [username]
[FAILED]

# /usr/sbin/vzctl exec 105 rpm -qa | grep postgresql
postgresql8.1-8.1.8-alt3
postgresql8.1-server-8.1.8-alt3
postgresql-common-1.0-alt3
Comment 7 Denis Smirnov 2007-05-03 22:04:25 MSD
postgresql8.2 работает правильно?
Comment 8 Ivan Fedorov 2007-05-03 23:58:21 MSD
юзайте 8.2 - там поправлено.
Comment 9 Artem Zolochevskiy 2007-05-12 19:48:30 MSD
8.2.4-alt2 - ok
Comment 10 Artem Zolochevskiy 2007-05-12 19:49:07 MSD
8.2.4-alt2 - ok