Pgsql troubleshooting & Iscsi
От | proj@free.fr |
---|---|
Тема | Pgsql troubleshooting & Iscsi |
Дата | |
Msg-id | 922594667.137763441.1455728849103.JavaMail.root@spooler3-g27.priv.proxad.net обсуждение исходный текст |
Ответы |
Re: Pgsql troubleshooting & Iscsi
Re: Pgsql troubleshooting & Iscsi Re: Pgsql troubleshooting & Iscsi |
Список | pgsql-general |
Hi everybody, I installed a postgresql database on Redhat 7.1 and I decided to move the database on an ISCSI device (LUN) inside a logicalvolume, mounted at starting of the machine (xfs formatted). The mounting point is /var/lib/pgsql At the boot of the server, postgresql.service is in failed status. In messages.log : systemd: mounting /var/lib/pgsql starting PostgreSQL database server kernel sdv: unknown partition table sd 2:0:0:0: [sdb] attached SCSI disk xfs (dm-4): Mounting V4 Filesystem postgresql-check-db-dir: "/var/lib/pgsql/data" is missing or empty postgresql.service: control process exited, code=exited status=1 Failed to start PostgreSQL database server. When I'm logged on the server, if it try to start manually the database : systemctl start postgresql --> OK (and I don'tlose any data, database is available) I think it's a problem of order in the boot process : network service must be started, then iscsi, then lvm etc... So I triedto force dependencies on the /usr/lib/systemd/system/postgresql.service adding "After=lvm-pgscan.service iscsi.service"etc... but the result is the same : failure in starting postgresql systemd: Starting Remote File Systems (Pre) systemd: Reached Remote File Systems (Pre) systemd: mounting /var/lib/pgsql systemd: starting PostgreSQL database server kernel sdb: unknown partition table postgresql-check-db-dir: "/var/lib/pgsql/data" is missing or empty kernel: xfs (dm-4): Mounting V4 Filesystem postgresql.service: control process exited, code=exited status=1 Failed to start PostgreSQL database server. Unit postgresql.service entered failed state sd 2:0:0:0: [sdb] attached SCSI disk starting LVM2 PV scan on device 8:16 kernel: xfs (dm-3): Ending clean mount systemd: Mounted /var/lib/pgsql Starting Remote File Systems Reached target Remote File Systems Any ideas ? regards, Magique
В списке pgsql-general по дате отправления: