* [sisyphus] postgresql из sisyphus, установка?
@ 2002-04-11 21:53 Anton Farygin
2002-04-12 3:38 ` Konstantin Timoshenko
0 siblings, 1 reply; 10+ messages in thread
From: Anton Farygin @ 2002-04-11 21:53 UTC (permalink / raw)
To: sisyphus
Вот - последняя версия PostgreSQL:
Building Dependency Tree... Done
The following NEW packages will be installed:
postgresql
0 packages upgraded, 1 newly installed, 0 to remove(replace) and 0 not
upgraded.
Need to get 0B/481kB of archives. After unpacking 1328kB will be used.
Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
Preparing... ###########################################
[100%]
1: postgresql ###########################################
[100%]
[root@riderbook root]# apt-get install postgresql-server
Processing File Dependencies... Done
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
mt-st
The following NEW packages will be installed:
mt-st postgresql-server
0 packages upgraded, 2 newly installed, 0 to remove(replace) and 0 not
upgraded.
Need to get 0B/1695kB of archives. After unpacking 3735kB will be used.
Do you want to continue? [Y/n]
Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
Preparing... ###########################################
[100%]
1: mt-st ###########################################
[ 50%]
2: postgresql-server ###########################################
[100%]
[root@riderbook root]# service postgresql start
Adjusting environment for postgresql:
[ OK ]
Creating default database: The files belonging to this database system
will be o
wned by user "postgres".
This user must also own the server process.
Fixing permissions on existing directory
/var/lib/pgsql-root/var/lib/pgsql/data.
.. ok
creating directory /var/lib/pgsql-root/var/lib/pgsql/data/base... ok
creating directory /var/lib/pgsql-root/var/lib/pgsql/data/global... ok
creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_xlog... ok
creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_clog... ok
creating template1 database in
/var/lib/pgsql-root/var/lib/pgsql/data/base/1...
rm: cannot lstat `.': Permission denied
initdb failed.
[FAILED]
Starting postgresql: FATAL 1: File /var/lib/pgsql/data/PG_VERSION is
missing. T
his is not a valid data directory.
[FAILED]
ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
Это что?
И как лечить?
Rgds,
Rider
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-11 21:53 [sisyphus] postgresql из sisyphus, установка? Anton Farygin
@ 2002-04-12 3:38 ` Konstantin Timoshenko
2002-04-12 5:22 ` Anton Farygin
` (3 more replies)
0 siblings, 4 replies; 10+ messages in thread
From: Konstantin Timoshenko @ 2002-04-12 3:38 UTC (permalink / raw)
To: sisyphus
On Fri, 12 Apr 2002 01:53:03 +0400
Anton Farygin <rider@altlinux.com> wrote:
> Вот - последняя версия PostgreSQL:
> Building Dependency Tree... Done
> The following NEW packages will be installed:
> postgresql
> 0 packages upgraded, 1 newly installed, 0 to remove(replace) and 0 not
> upgraded.
> Need to get 0B/481kB of archives. After unpacking 1328kB will be used.
> Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
> Preparing... ###########################################
> [100%]
> 1: postgresql ###########################################
> [100%]
> [root@riderbook root]# apt-get install postgresql-server
> Processing File Dependencies... Done
> Reading Package Lists... Done
> Building Dependency Tree... Done
> The following extra packages will be installed:
> mt-st
> The following NEW packages will be installed:
> mt-st postgresql-server
> 0 packages upgraded, 2 newly installed, 0 to remove(replace) and 0 not
> upgraded.
> Need to get 0B/1695kB of archives. After unpacking 3735kB will be used.
> Do you want to continue? [Y/n]
> Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
> Preparing... ###########################################
> [100%]
> 1: mt-st ###########################################
> [ 50%]
> 2: postgresql-server ###########################################
> [100%]
> [root@riderbook root]# service postgresql start
> Adjusting environment for postgresql:
> [ OK ]
> Creating default database: The files belonging to this database system
> will be o
> wned by user "postgres".
> This user must also own the server process.
>
> Fixing permissions on existing directory
> /var/lib/pgsql-root/var/lib/pgsql/data.
> .. ok
> creating directory /var/lib/pgsql-root/var/lib/pgsql/data/base... ok
> creating directory /var/lib/pgsql-root/var/lib/pgsql/data/global... ok
> creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_xlog... ok
> creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_clog... ok
> creating template1 database in
> /var/lib/pgsql-root/var/lib/pgsql/data/base/1...
> rm: cannot lstat `.': Permission denied
>
> initdb failed.
>
> [FAILED]
> Starting postgresql: FATAL 1: File /var/lib/pgsql/data/PG_VERSION is
> missing. T
> his is not a valid data directory.
>
> [FAILED]
> ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
>
> Это что?
какая версия стояла и на какую менял можно узнать?
--
Kostya.
mailto:kt@tura.ru
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 3:38 ` Konstantin Timoshenko
@ 2002-04-12 5:22 ` Anton Farygin
2002-04-12 5:29 ` Anton Farygin
` (2 subsequent siblings)
3 siblings, 0 replies; 10+ messages in thread
From: Anton Farygin @ 2002-04-12 5:22 UTC (permalink / raw)
To: sisyphus
Konstantin Timoshenko wrote:
>On Fri, 12 Apr 2002 01:53:03 +0400
>Anton Farygin <rider@altlinux.com> wrote:
>
>>Вот - последняя версия PostgreSQL:
>>Building Dependency Tree... Done
>>The following NEW packages will be installed:
>> postgresql
>>0 packages upgraded, 1 newly installed, 0 to remove(replace) and 0 not
>>upgraded.
>>Need to get 0B/481kB of archives. After unpacking 1328kB will be used.
>>Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
>>Preparing... ###########################################
>>[100%]
>>1: postgresql ###########################################
>>[100%]
>>[root@riderbook root]# apt-get install postgresql-server
>>Processing File Dependencies... Done
>>Reading Package Lists... Done
>>Building Dependency Tree... Done
>>The following extra packages will be installed:
>> mt-st
>>The following NEW packages will be installed:
>> mt-st postgresql-server
>>0 packages upgraded, 2 newly installed, 0 to remove(replace) and 0 not
>>upgraded.
>>Need to get 0B/1695kB of archives. After unpacking 3735kB will be used.
>>Do you want to continue? [Y/n]
>>Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
>>Preparing... ###########################################
>>[100%]
>>1: mt-st ###########################################
>>[ 50%]
>>2: postgresql-server ###########################################
>>[100%]
>>[root@riderbook root]# service postgresql start
>>Adjusting environment for postgresql:
>>[ OK ]
>>Creating default database: The files belonging to this database system
>>will be o
>>wned by user "postgres".
>>This user must also own the server process.
>>
>>Fixing permissions on existing directory
>>/var/lib/pgsql-root/var/lib/pgsql/data.
>>.. ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/base... ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/global... ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_xlog... ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_clog... ok
>>creating template1 database in
>>/var/lib/pgsql-root/var/lib/pgsql/data/base/1...
>>rm: cannot lstat `.': Permission denied
>>
>>initdb failed.
>>
>>[FAILED]
>>Starting postgresql: FATAL 1: File /var/lib/pgsql/data/PG_VERSION is
>>missing. T
>>his is not a valid data directory.
>>
>>[FAILED]
>>ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
>>
>>Это что?
>>
>какая версия стояла и на какую менял можно узнать?
>
Не стояла никакая... это первая установка.
Rgds,
Rider
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 3:38 ` Konstantin Timoshenko
2002-04-12 5:22 ` Anton Farygin
@ 2002-04-12 5:29 ` Anton Farygin
2002-04-12 5:59 ` Anton Farygin
2002-04-12 8:29 ` Maxim Dzumanenko
3 siblings, 0 replies; 10+ messages in thread
From: Anton Farygin @ 2002-04-12 5:29 UTC (permalink / raw)
To: sisyphus
Konstantin Timoshenko wrote:
>On Fri, 12 Apr 2002 01:53:03 +0400
>Anton Farygin <rider@altlinux.com> wrote:
>
>>Вот - последняя версия PostgreSQL:
>>Building Dependency Tree... Done
>>The following NEW packages will be installed:
>> postgresql
>>0 packages upgraded, 1 newly installed, 0 to remove(replace) and 0 not
>>upgraded.
>>Need to get 0B/481kB of archives. After unpacking 1328kB will be used.
>>Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
>>Preparing... ###########################################
>>[100%]
>>1: postgresql ###########################################
>>[100%]
>>[root@riderbook root]# apt-get install postgresql-server
>>Processing File Dependencies... Done
>>Reading Package Lists... Done
>>Building Dependency Tree... Done
>>The following extra packages will be installed:
>> mt-st
>>The following NEW packages will be installed:
>> mt-st postgresql-server
>>0 packages upgraded, 2 newly installed, 0 to remove(replace) and 0 not
>>upgraded.
>>Need to get 0B/1695kB of archives. After unpacking 3735kB will be used.
>>Do you want to continue? [Y/n]
>>Executing RPM (/bin/rpm -Uv --replacepkgs -h --fancypercent)...
>>Preparing... ###########################################
>>[100%]
>>1: mt-st ###########################################
>>[ 50%]
>>2: postgresql-server ###########################################
>>[100%]
>>[root@riderbook root]# service postgresql start
>>Adjusting environment for postgresql:
>>[ OK ]
>>Creating default database: The files belonging to this database system
>>will be o
>>wned by user "postgres".
>>This user must also own the server process.
>>
>>Fixing permissions on existing directory
>>/var/lib/pgsql-root/var/lib/pgsql/data.
>>.. ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/base... ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/global... ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_xlog... ok
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_clog... ok
>>creating template1 database in
>>/var/lib/pgsql-root/var/lib/pgsql/data/base/1...
>>rm: cannot lstat `.': Permission denied
>>
>>initdb failed.
>>
>>[FAILED]
>>Starting postgresql: FATAL 1: File /var/lib/pgsql/data/PG_VERSION is
>>missing. T
>>his is not a valid data directory.
>>
>>[FAILED]
>>ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
>>
>>Это что?
>>
>какая версия стояла и на какую менял можно узнать?
>
Ставил версию:
[rider@riderbook Mandrake]$ rpm -qa|grep postgre
postgresql-libs-7.2.1-alt1
postgresql-7.2.1-alt1
postgresql-server-7.2.1-alt1
Rgds,
Rider
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 3:38 ` Konstantin Timoshenko
2002-04-12 5:22 ` Anton Farygin
2002-04-12 5:29 ` Anton Farygin
@ 2002-04-12 5:59 ` Anton Farygin
2002-04-12 8:29 ` Maxim Dzumanenko
3 siblings, 0 replies; 10+ messages in thread
From: Anton Farygin @ 2002-04-12 5:59 UTC (permalink / raw)
To: sisyphus
Konstantin Timoshenko wrote:
>On Fri, 12 Apr 2002 01:53:03 +0400
>Anton Farygin <rider@altlinux.com> wrote:
>
>>Вот - последняя версия PostgreSQL:
>>Building Dependency Tree... Done
>>The following NEW packages will be installed:
>> postgresql
>>
<skip>
>>creating directory /var/lib/pgsql-root/var/lib/pgsql/data/pg_clog... ok
>>creating template1 database in
>>/var/lib/pgsql-root/var/lib/pgsql/data/base/1...
>>rm: cannot lstat `.': Permission denied
>>
>>initdb failed.
>>
>>[FAILED]
>>Starting postgresql: FATAL 1: File /var/lib/pgsql/data/PG_VERSION is
>>missing. T
>>his is not a valid data directory.
>>
>>[FAILED]
>>ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
>>
>>Это что?
>>
>какая версия стояла и на какую менял можно узнать?
>
Ошибка повторяется всегда при первой установке и запуске postgresql-server.
Rgds,
Rider
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 3:38 ` Konstantin Timoshenko
` (2 preceding siblings ...)
2002-04-12 5:59 ` Anton Farygin
@ 2002-04-12 8:29 ` Maxim Dzumanenko
2002-04-12 9:13 ` [sisyphus] " Alex Volkov
3 siblings, 1 reply; 10+ messages in thread
From: Maxim Dzumanenko @ 2002-04-12 8:29 UTC (permalink / raw)
To: sisyphus
[-- Attachment #1: Type: text/plain, Size: 669 bytes --]
On Fri, 12 Apr 2002 09:38:09 +0600
Konstantin Timoshenko <kt@tura.ru> wrote:
> > [FAILED]
> > ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
> >
> > Это что?
> какая версия стояла и на какую менял можно узнать?
Кстати, у меня postgresql так и не старует при запуске системы -
выводит вышеуказанное сообюшение,
а вот при /etc/rc.d/init.d/postrgesql start/stop/restart все нормально
Это я один такой несчастливый?
Может ему чего-то не хватает, что запускается позже?
Для справки обновлял 7.2 - 7.2.1 init.d/postgresql.rpmnew менял на posgtresql
--
С Уважением,
Максим Дзюманенко
[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]
^ permalink raw reply [flat|nested] 10+ messages in thread
* [sisyphus] Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 8:29 ` Maxim Dzumanenko
@ 2002-04-12 9:13 ` Alex Volkov
2002-04-12 9:23 ` Sergey Bolshakov
2002-04-13 8:30 ` Maxim Dzumanenko
0 siblings, 2 replies; 10+ messages in thread
From: Alex Volkov @ 2002-04-12 9:13 UTC (permalink / raw)
To: Maxim Dzumanenko
>> > [FAILED]
>> > ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
>> >
>> > Это что?
>> какая версия стояла и на какую менял можно узнать?
MD> Кстати, у меня postgresql так и не старует при запуске системы -
MD> выводит вышеуказанное сообюшение,
MD> а вот при /etc/rc.d/init.d/postrgesql start/stop/restart все нормально
MD> Это я один такой несчастливый?
MD> Может ему чего-то не хватает, что запускается позже?
MD> Для справки обновлял 7.2 - 7.2.1 init.d/postgresql.rpmnew менял на posgtresql
У меня было то же самое. Версия 7.2-alt5. IMHO это из-за того, что
скрипт пытается создать симлинк для сокета из chroot tmp в /tmp, а
сервер еще не поднялся и сокета в chroot'е нет :) Свой я вылечил так:
--- postgresql Thu Mar 7 14:38:17 2002
+++ postgresql-new Thu Mar 28 09:10:22 2002
@@ -108,7 +108,7 @@
echo `pidofproc postmaster` > /var/run/postmaster.pid
if [ $PG_CHROOT_DIR ];
then
- filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`
+ until filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`; do sleep 1s; done
for f in $filelist; do
if [ -S "$f" ]; then
ln -s $f /tmp/${f##*/} >/dev/null 2>&1
Потестите на своих системах, авось поможет :-)
--
Best regards,
Alex mailto:wn@ssserv.scm.ru
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 9:13 ` [sisyphus] " Alex Volkov
@ 2002-04-12 9:23 ` Sergey Bolshakov
2002-04-15 12:02 ` Konstantin Timoshenko
2002-04-13 8:30 ` Maxim Dzumanenko
1 sibling, 1 reply; 10+ messages in thread
From: Sergey Bolshakov @ 2002-04-12 9:23 UTC (permalink / raw)
To: sisyphus
## On Fri, 12 Apr 2002 15:13:54 +0600
## you wrote:
>>> > [FAILED]
>>> > ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
>>> >
>>> > Это что?
>>> какая версия стояла и на какую менял можно узнать?
MD>> Кстати, у меня postgresql так и не старует при запуске системы -
MD>> выводит вышеуказанное сообюшение,
MD>> а вот при /etc/rc.d/init.d/postrgesql start/stop/restart все нормально
MD>> Это я один такой несчастливый?
MD>> Может ему чего-то не хватает, что запускается позже?
MD>> Для справки обновлял 7.2 - 7.2.1 init.d/postgresql.rpmnew менял на posgtresql
AV> У меня было то же самое. Версия 7.2-alt5. IMHO это из-за того, что
AV> скрипт пытается создать симлинк для сокета из chroot tmp в /tmp, а
AV> сервер еще не поднялся и сокета в chroot'е нет :) Свой я вылечил так:
AV> --- postgresql Thu Mar 7 14:38:17 2002
AV> +++ postgresql-new Thu Mar 28 09:10:22 2002
AV> @@ -108,7 +108,7 @@
AV> echo `pidofproc postmaster` > /var/run/postmaster.pid
AV> if [ $PG_CHROOT_DIR ];
AV> then
AV> - filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`
AV> + until filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`; do sleep 1s; done
AV> for f in $filelist; do
AV> if [ -S "$f" ]; then
AV> ln -s $f /tmp/${f##*/} >/dev/null 2>&1
AV> Потестите на своих системах, авось поможет :-)
Было замечено также следующее: после издыхания постгреса (причины не
рассматриваем :) перезапустить его возможно только после прибития ручками
файлика /var/lib/pgsql/data/postmaster.pid.
--
Трули ерз, Сергей.
"[Open Source] programming is like sex, one mistake and you have to support it
for the rest of your life." --- M. Sinz, CBM Inc.
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 9:23 ` Sergey Bolshakov
@ 2002-04-15 12:02 ` Konstantin Timoshenko
0 siblings, 0 replies; 10+ messages in thread
From: Konstantin Timoshenko @ 2002-04-15 12:02 UTC (permalink / raw)
To: sisyphus
On 12 Apr 2002 12:23:43 +0300
Sergey Bolshakov <s.bolshakov@belcaf.com> wrote:
>
> ## On Fri, 12 Apr 2002 15:13:54 +0600
> ## you wrote:
>
> >>> > [FAILED]
> >>> > ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
> >>> >
> >>> > Это что?
> >>> какая версия стояла и на какую менял можно узнать?
>
> MD>> Кстати, у меня postgresql так и не старует при запуске системы -
> MD>> выводит вышеуказанное сообюшение,
> MD>> а вот при /etc/rc.d/init.d/postrgesql start/stop/restart все
> нормально MD>> Это я один такой несчастливый?
> MD>> Может ему чего-то не хватает, что запускается позже?
>
> MD>> Для справки обновлял 7.2 - 7.2.1 init.d/postgresql.rpmnew менял на
> posgtresql AV> У меня было то же самое. Версия 7.2-alt5. IMHO это
> из-за того, что AV> скрипт пытается создать симлинк для сокета из
> chroot tmp в /tmp, а AV> сервер еще не поднялся и сокета в chroot'е нет
> :) Свой я вылечил так:
>
> AV> --- postgresql Thu Mar 7 14:38:17 2002
> AV> +++ postgresql-new Thu Mar 28 09:10:22 2002
> AV> @@ -108,7 +108,7 @@
> AV> echo `pidofproc postmaster` >
> /var/run/postmaster.pid AV> if [ $PG_CHROOT_DIR ];
> AV> then
> AV> - filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`
> AV> + until filelist=`ls
> $PG_CHROOT_DIR/tmp/.s.PGSQL.*`; do sleep 1s; done AV>
> for f in $filelist; do AV> if [ -S "$f" ];
> then AV> ln -s $f /tmp/${f##*/} >/dev/null
> 2>&1
>
> AV> Потестите на своих системах, авось поможет :-)
> Было замечено также следующее: после издыхания постгреса (причины не
> рассматриваем :) перезапустить его возможно только после прибития
> ручками файлика /var/lib/pgsql/data/postmaster.pid.
исправленно в 7.2.1-alt2, также исправленно ошибка при запуске из под service.
--
Kostya.
mailto:kt@tura.ru
^ permalink raw reply [flat|nested] 10+ messages in thread
* Re: [sisyphus] Re: [sisyphus] postgresql из sisyphus, установка?
2002-04-12 9:13 ` [sisyphus] " Alex Volkov
2002-04-12 9:23 ` Sergey Bolshakov
@ 2002-04-13 8:30 ` Maxim Dzumanenko
1 sibling, 0 replies; 10+ messages in thread
From: Maxim Dzumanenko @ 2002-04-13 8:30 UTC (permalink / raw)
To: sisyphus
[-- Attachment #1.1: Type: text/plain, Size: 6131 bytes --]
On Fri, 12 Apr 2002 15:13:54 +0600
Alex Volkov <wn@ssserv.scm.ru> wrote:
> >> > [FAILED]
> >> > ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
> MD> Кстати, у меня postgresql так и не старует при запуске системы -
> MD> выводит вышеуказанное сообюшение,
> MD> а вот при /etc/rc.d/init.d/postrgesql start/stop/restart все нормально
> У меня было то же самое. Версия 7.2-alt5. IMHO это из-за того, что
> скрипт пытается создать симлинк для сокета из chroot tmp в /tmp, а
> сервер еще не поднялся и сокета в chroot'е нет :) Свой я вылечил так:
> + until filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`; do sleep 1s; done
Не помогло, та же надпись, только в цикле
После добавления отладочной опции -d 4 выяснилась следующая разница
При запуске системы постгрес НЕ ВИДИТ переменную окружения TMPDIR которая ему установлена
в /etc/rc.d/init.d/postgresql
Очевидно это и есть причина такого поведения
А вот почему не видит - это надо спросить у кого-то другого
Вот лог при запуске системы
Apr 13 11:09:26 max postgresql: Adjusting environment for postgresql: succeeded
Apr 13 11:09:27 max postmaster: /usr/bin/postmaster: PostmasterMain: initial environ dump:
Apr 13 11:09:27 max postmaster: -----------------------------------------
Apr 13 11:09:27 max postmaster: ^IPWD=/
Apr 13 11:09:27 max postmaster: ^IHOSTNAME=max.april.local
Apr 13 11:09:27 max postmaster: ^ICONSOLE=/dev/console
Apr 13 11:09:27 max postmaster: ^ILOGLEVEL=1
Apr 13 11:09:27 max postmaster: ^IPREVLEVEL=N
Apr 13 11:09:27 max postmaster: ^Irunlevel=3
Apr 13 11:09:27 max postmaster: ^IBOOTUP=color
Apr 13 11:09:27 max postmaster: ^IMACHTYPE=i586-alt-linux-gnu
Apr 13 11:09:27 max postmaster: ^ISHLVL=2
Apr 13 11:09:27 max postmaster: ^Iprevious=N
Apr 13 11:09:27 max postmaster: ^IBOOT_IMAGE=2418-alt4-up
Apr 13 11:09:27 max postmaster: ^ISHELL=/bin/bash
Apr 13 11:09:27 max postmaster: ^IHOSTTYPE=i586
Apr 13 11:09:27 max postmaster: ^IOSTYPE=linux-gnu
Apr 13 11:09:27 max postmaster: ^IHOME=/
Apr 13 11:09:27 max postmaster: ^ITERM=linux
Apr 13 11:09:27 max postmaster: ^IPGDATA=/var/lib/pgsql/data
Apr 13 11:09:27 max postmaster: ^IPATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
Apr 13 11:09:27 max postmaster: ^IRUNLEVEL=3
Apr 13 11:09:27 max postmaster: ^IINIT_VERSION=sysvinit-2.84
Apr 13 11:09:27 max postmaster: ^I_=/bin/nice
Apr 13 11:09:27 max postmaster: -----------------------------------------
Apr 13 11:09:27 max postgresql: postmaster startup succeeded
После ручного запуска
Кв╕ 13 11:11:58 max last message repeated 3 times
Apr 13 11:12:12 max postgresql: Adjusting environment for postgresql: succeeded
Apr 13 11:12:12 max postmaster: /usr/bin/postmaster: PostmasterMain: initial environ dump:
Apr 13 11:12:12 max postmaster: -----------------------------------------
Apr 13 11:12:12 max postmaster: ^IPWD=/root
Apr 13 11:12:12 max postmaster: ^ICATALINA_HOME=/usr/local/jakarta-tomcat
Apr 13 11:12:12 max postmaster: ^ITMPDIR=/var/lib/pgsql-root/tmp
Apr 13 11:12:12 max postmaster: ^ILC_MESSAGES=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^IHOSTNAME=max.april.local
Apr 13 11:12:12 max postmaster: ^IHISTFILESIZE=9999
Apr 13 11:12:12 max postmaster: ^ICLASSPATH=:/usr/share/pgsql/jdbc7.0-1.2.jar:/usr/local/mysqljdbc/caucho-jdbc-mysql-0.2.7.jar:.:/usr/local/xalan/bin/xalan.jar:/usr/local/xalan/bin/xerces.jar
Apr 13 11:12:12 max postmaster: ^ILESSKEY=/etc/.less
Apr 13 11:12:12 max postmaster: ^ILESSOPEN=|/usr/bin/lesspipe.sh %s
Apr 13 11:12:12 max postmaster: ^ILANGUAGE=POSIX
Apr 13 11:12:12 max postmaster: ^ILESS=-MM
Apr 13 11:12:12 max postmaster: ^IUSER=root
Apr 13 11:12:12 max postmaster: ^ILS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.tar=01;31:*.tgz=01;31:*.tgy=01;31:*.tbz2=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lha=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:*.tiff=01;35:
Apr 13 11:12:12 max postmaster: ^IMACHTYPE=i586-alt-linux-gnu
Apr 13 11:12:12 max postmaster: ^IMAIL=/var/mail/root
Apr 13 11:12:12 max postmaster: ^ICVS_RSH=ssh
Apr 13 11:12:12 max postmaster: ^IINPUTRC=/etc/inputrc
Apr 13 11:12:12 max postmaster: ^IBASH_ENV=/root/.bashrc
Apr 13 11:12:12 max postmaster: ^ILANG=POSIX
Apr 13 11:12:12 max postmaster: ^IJAVA_HOME=/usr/local/IBMJava2-13
Apr 13 11:12:12 max postmaster: ^ILC_NUMERIC=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^ILOGNAME=root
Apr 13 11:12:12 max postmaster: ^ISHLVL=2
Apr 13 11:12:12 max postmaster: ^ILC_CTYPE=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^IMINICOM= -c on -8
Apr 13 11:12:12 max postmaster: ^IMPAGE=-CKOI8-U
Apr 13 11:12:12 max postmaster: ^ISHELL=/bin/bash
Apr 13 11:12:12 max postmaster: ^IJDK_HOME=/usr/local/j2sdk1.4.0
Apr 13 11:12:12 max postmaster: ^IUSERNAME=
Apr 13 11:12:12 max postmaster: ^IHOSTTYPE=i586
Apr 13 11:12:12 max postmaster: ^IOSTYPE=linux-gnu
Apr 13 11:12:12 max postmaster: ^IHISTSIZE=9999
Apr 13 11:12:12 max postmaster: ^ITERM=linux
Apr 13 11:12:12 max postmaster: ^IHOME=/root
Apr 13 11:12:12 max postmaster: ^IPGDATA=/var/lib/pgsql/data
Apr 13 11:12:12 max postmaster: ^IPATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
Apr 13 11:12:12 max postmaster: ^ILC_MONETARY=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^ILC_COLLATE=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^Imc=() { mkdir -p $HOME/.mc/tmp 2>/dev/null;
Apr 13 11:12:12 max postmaster: chmod 700 $HOME/.mc/tmp;
Apr 13 11:12:12 max postmaster: MC=$HOME/.mc/tmp/mc-$$;
Apr 13 11:12:12 max postmaster: /usr/bin/mc -P "$@" >"$MC";
Apr 13 11:12:12 max postmaster: cd "`cat $MC`";
Apr 13 11:12:12 max postmaster: rm -f "$MC";
Apr 13 11:12:12 max postmaster: unset MC
Apr 13 11:12:12 max postmaster: }
Apr 13 11:12:12 max postmaster: ^I_=/bin/nice
Apr 13 11:12:12 max postmaster: -----------------------------------------
Apr 13 11:12:12 max postgresql: postmaster startup succeeded
емы:
--
С Уважением,
Максим Дзюманенко
[-- Attachment #1.2: 00000001.mimetmp --]
[-- Type: text/plain, Size: 6131 bytes --]
On Fri, 12 Apr 2002 15:13:54 +0600
Alex Volkov <wn@ssserv.scm.ru> wrote:
> >> > [FAILED]
> >> > ls: /var/lib/pgsql-root/tmp/.s.PGSQL.*: No such file or directory
> MD> ëÓÔÁÔÉ, Õ ÍÅÎÑ postgresql ÔÁË É ÎÅ ÓÔÁÒÕÅÔ ÐÒÉ ÚÁÐÕÓËÅ ÓÉÓÔÅÍÙ -
> MD> ×Ù×ÏÄÉÔ ×ÙÛÅÕËÁÚÁÎÎÏÅ ÓÏÏÂÀÛÅÎÉÅ,
> MD> Á ×ÏÔ ÐÒÉ /etc/rc.d/init.d/postrgesql start/stop/restart ×ÓÅ ÎÏÒÍÁÌØÎÏ
> õ ÍÅÎÑ ÂÙÌÏ ÔÏ ÖÅ ÓÁÍÏÅ. ÷ÅÒÓÉÑ 7.2-alt5. IMHO ÜÔÏ ÉÚ-ÚÁ ÔÏÇÏ, ÞÔÏ
> ÓËÒÉÐÔ ÐÙÔÁÅÔÓÑ ÓÏÚÄÁÔØ ÓÉÍÌÉÎË ÄÌÑ ÓÏËÅÔÁ ÉÚ chroot tmp × /tmp, Á
> ÓÅÒ×ÅÒ ÅÝÅ ÎÅ ÐÏÄÎÑÌÓÑ É ÓÏËÅÔÁ × chroot'Å ÎÅÔ :) ó×ÏÊ Ñ ×ÙÌÅÞÉÌ ÔÁË:
> + until filelist=`ls $PG_CHROOT_DIR/tmp/.s.PGSQL.*`; do sleep 1s; done
îÅ ÐÏÍÏÇÌÏ, ÔÁ ÖÅ ÎÁÄÐÉÓØ, ÔÏÌØËÏ × ÃÉËÌÅ
ðÏÓÌÅ ÄÏÂÁ×ÌÅÎÉÑ ÏÔÌÁÄÏÞÎÏÊ ÏÐÃÉÉ -d4 ×ÙÑÓÎÉÌÁÓØ ÓÌÅÄÕÀÝÁÑ ÒÁÚÎÉÃÁ
ðÒÉ ÚÁÐÕÓËÅ ÓÉÓÔÅÍÙ ÐÏÓÔÇÒÅÓ îå ÷éäéô ÐÅÒÅÍÅÎÎÕÀ ÏËÒÕÖÅÎÉÑ TMPDIR ËÏÔÏÒÁÑ ÅÍÕ ÕÓÔÁÎÏ×ÌÅÎÁ
× /etc/rc.d/init.d/postgresql
ïÞÅ×ÉÄÎÏ ÜÔÏ É ÅÓÔØ ÐÒÉÞÉÎÁ ÔÁËÏÇÏ ÐÏ×ÅÄÅÎÉÑ
á ×ÏÔ ÐÏÞÅÍÕ ÎÅ ×ÉÄÉÔ - ÜÔÏ ÎÁÄÏ ÓÐÒÏÓÉÔØ Õ ËÏÇÏ-ÔÏ ÄÒÕÇÏÇÏ
÷ÏÔ ÌÏÇ ÐÒÉ ÚÁÐÕÓËÅ ÓÉÓÔÅÍÙ
Apr 13 11:09:26 max postgresql: Adjusting environment for postgresql: succeeded
Apr 13 11:09:27 max postmaster: /usr/bin/postmaster: PostmasterMain: initial environ dump:
Apr 13 11:09:27 max postmaster: -----------------------------------------
Apr 13 11:09:27 max postmaster: ^IPWD=/
Apr 13 11:09:27 max postmaster: ^IHOSTNAME=max.april.local
Apr 13 11:09:27 max postmaster: ^ICONSOLE=/dev/console
Apr 13 11:09:27 max postmaster: ^ILOGLEVEL=1
Apr 13 11:09:27 max postmaster: ^IPREVLEVEL=N
Apr 13 11:09:27 max postmaster: ^Irunlevel=3
Apr 13 11:09:27 max postmaster: ^IBOOTUP=color
Apr 13 11:09:27 max postmaster: ^IMACHTYPE=i586-alt-linux-gnu
Apr 13 11:09:27 max postmaster: ^ISHLVL=2
Apr 13 11:09:27 max postmaster: ^Iprevious=N
Apr 13 11:09:27 max postmaster: ^IBOOT_IMAGE=2418-alt4-up
Apr 13 11:09:27 max postmaster: ^ISHELL=/bin/bash
Apr 13 11:09:27 max postmaster: ^IHOSTTYPE=i586
Apr 13 11:09:27 max postmaster: ^IOSTYPE=linux-gnu
Apr 13 11:09:27 max postmaster: ^IHOME=/
Apr 13 11:09:27 max postmaster: ^ITERM=linux
Apr 13 11:09:27 max postmaster: ^IPGDATA=/var/lib/pgsql/data
Apr 13 11:09:27 max postmaster: ^IPATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
Apr 13 11:09:27 max postmaster: ^IRUNLEVEL=3
Apr 13 11:09:27 max postmaster: ^IINIT_VERSION=sysvinit-2.84
Apr 13 11:09:27 max postmaster: ^I_=/bin/nice
Apr 13 11:09:27 max postmaster: -----------------------------------------
Apr 13 11:09:27 max postgresql: postmaster startup succeeded
ðÏÓÌÅ ÒÕÞÎÏÇÏ ÚÁÐÕÓËÁ
ëצ 13 11:11:58 max last message repeated 3 times
Apr 13 11:12:12 max postgresql: Adjusting environment for postgresql: succeeded
Apr 13 11:12:12 max postmaster: /usr/bin/postmaster: PostmasterMain: initial environ dump:
Apr 13 11:12:12 max postmaster: -----------------------------------------
Apr 13 11:12:12 max postmaster: ^IPWD=/root
Apr 13 11:12:12 max postmaster: ^ICATALINA_HOME=/usr/local/jakarta-tomcat
Apr 13 11:12:12 max postmaster: ^ITMPDIR=/var/lib/pgsql-root/tmp
Apr 13 11:12:12 max postmaster: ^ILC_MESSAGES=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^IHOSTNAME=max.april.local
Apr 13 11:12:12 max postmaster: ^IHISTFILESIZE=9999
Apr 13 11:12:12 max postmaster: ^ICLASSPATH=:/usr/share/pgsql/jdbc7.0-1.2.jar:/usr/local/mysqljdbc/caucho-jdbc-mysql-0.2.7.jar:.:/usr/local/xalan/bin/xalan.jar:/usr/local/xalan/bin/xerces.jar
Apr 13 11:12:12 max postmaster: ^ILESSKEY=/etc/.less
Apr 13 11:12:12 max postmaster: ^ILESSOPEN=|/usr/bin/lesspipe.sh %s
Apr 13 11:12:12 max postmaster: ^ILANGUAGE=POSIX
Apr 13 11:12:12 max postmaster: ^ILESS=-MM
Apr 13 11:12:12 max postmaster: ^IUSER=root
Apr 13 11:12:12 max postmaster: ^ILS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.tar=01;31:*.tgz=01;31:*.tgy=01;31:*.tbz2=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lha=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:*.tiff=01;35:
Apr 13 11:12:12 max postmaster: ^IMACHTYPE=i586-alt-linux-gnu
Apr 13 11:12:12 max postmaster: ^IMAIL=/var/mail/root
Apr 13 11:12:12 max postmaster: ^ICVS_RSH=ssh
Apr 13 11:12:12 max postmaster: ^IINPUTRC=/etc/inputrc
Apr 13 11:12:12 max postmaster: ^IBASH_ENV=/root/.bashrc
Apr 13 11:12:12 max postmaster: ^ILANG=POSIX
Apr 13 11:12:12 max postmaster: ^IJAVA_HOME=/usr/local/IBMJava2-13
Apr 13 11:12:12 max postmaster: ^ILC_NUMERIC=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^ILOGNAME=root
Apr 13 11:12:12 max postmaster: ^ISHLVL=2
Apr 13 11:12:12 max postmaster: ^ILC_CTYPE=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^IMINICOM= -c on -8
Apr 13 11:12:12 max postmaster: ^IMPAGE=-CKOI8-U
Apr 13 11:12:12 max postmaster: ^ISHELL=/bin/bash
Apr 13 11:12:12 max postmaster: ^IJDK_HOME=/usr/local/j2sdk1.4.0
Apr 13 11:12:12 max postmaster: ^IUSERNAME=
Apr 13 11:12:12 max postmaster: ^IHOSTTYPE=i586
Apr 13 11:12:12 max postmaster: ^IOSTYPE=linux-gnu
Apr 13 11:12:12 max postmaster: ^IHISTSIZE=9999
Apr 13 11:12:12 max postmaster: ^ITERM=linux
Apr 13 11:12:12 max postmaster: ^IHOME=/root
Apr 13 11:12:12 max postmaster: ^IPGDATA=/var/lib/pgsql/data
Apr 13 11:12:12 max postmaster: ^IPATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
Apr 13 11:12:12 max postmaster: ^ILC_MONETARY=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^ILC_COLLATE=uk_UA.KOI8-U
Apr 13 11:12:12 max postmaster: ^Imc=() { mkdir -p $HOME/.mc/tmp 2>/dev/null;
Apr 13 11:12:12 max postmaster: chmod 700 $HOME/.mc/tmp;
Apr 13 11:12:12 max postmaster: MC=$HOME/.mc/tmp/mc-$$;
Apr 13 11:12:12 max postmaster: /usr/bin/mc -P "$@" >"$MC";
Apr 13 11:12:12 max postmaster: cd "`cat $MC`";
Apr 13 11:12:12 max postmaster: rm -f "$MC";
Apr 13 11:12:12 max postmaster: unset MC
Apr 13 11:12:12 max postmaster: }
Apr 13 11:12:12 max postmaster: ^I_=/bin/nice
Apr 13 11:12:12 max postmaster: -----------------------------------------
Apr 13 11:12:12 max postgresql: postmaster startup succeeded
ÅÍÙ:
--
ó õ×ÁÖÅÎÉÅÍ,
íÁËÓÉÍ äÚÀÍÁÎÅÎËÏ
[-- Attachment #1.3: 00000000.mimetmp --]
[-- Type: application/pgp-signature, Size: 191 bytes --]
[-- Attachment #2: Type: application/pgp-signature, Size: 189 bytes --]
^ permalink raw reply [flat|nested] 10+ messages in thread
end of thread, other threads:[~2002-04-15 12:02 UTC | newest]
Thread overview: 10+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2002-04-11 21:53 [sisyphus] postgresql из sisyphus, установка? Anton Farygin
2002-04-12 3:38 ` Konstantin Timoshenko
2002-04-12 5:22 ` Anton Farygin
2002-04-12 5:29 ` Anton Farygin
2002-04-12 5:59 ` Anton Farygin
2002-04-12 8:29 ` Maxim Dzumanenko
2002-04-12 9:13 ` [sisyphus] " Alex Volkov
2002-04-12 9:23 ` Sergey Bolshakov
2002-04-15 12:02 ` Konstantin Timoshenko
2002-04-13 8:30 ` Maxim Dzumanenko
ALT Linux Sisyphus discussions
This inbox may be cloned and mirrored by anyone:
git clone --mirror http://lore.altlinux.org/sisyphus/0 sisyphus/git/0.git
# If you have public-inbox 1.1+ installed, you may
# initialize and index your mirror using the following commands:
public-inbox-init -V2 sisyphus sisyphus/ http://lore.altlinux.org/sisyphus \
sisyphus@altlinux.ru sisyphus@altlinux.org sisyphus@lists.altlinux.org sisyphus@lists.altlinux.ru sisyphus@lists.altlinux.com sisyphus@linuxteam.iplabs.ru sisyphus@list.linux-os.ru
public-inbox-index sisyphus
Example config snippet for mirrors.
Newsgroup available over NNTP:
nntp://lore.altlinux.org/org.altlinux.lists.sisyphus
AGPL code for this site: git clone https://public-inbox.org/public-inbox.git