Bug 10807 - postgresql не стартует
Summary: postgresql не стартует
Status: CLOSED FIXED
Alias: None
Product: Sisyphus
Classification: Development
Component: postgresql8.0-server (show other bugs)
Version: unstable
Hardware: all Linux
: P2 major
Assignee: Ivan Fedorov
QA Contact: qa-sisyphus
URL:
Keywords:
: 11394 11425 (view as bug list)
Depends on:
Blocks:
 
Reported: 2007-02-08 23:20 MSK by Artem Zolochevskiy
Modified: 2008-06-13 12:16 MSD (History)
6 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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