PDA

توجه ! این یک نسخه آرشیو شده میباشد و در این حالت شما عکسی را مشاهده نمیکنید برای مشاهده کامل متن و عکسها بر روی لینک مقابل کلیک کنید : ارور نصب IBSng در Centos7



a.n1
December 6th, 2020, 01:41
createdb IBSng
createdb: could not connect to database template1: FATAL: role "root" does not exist


باسلام موقع این دستور این ارور میده
postgrescreatedb IBSngcreateuser ibscreatelang plpgsql IBSngexit

این دستور هم کار نمی کند


[root@static ~]# tar -xvjf IBSng-A1.24.tar.bz2 -C /usr/local
tar (child): bzip2: Cannot exec: No such file or directory
tar (child): Error is not recoverable: exiting now
tar: Child returned status 2
tar: Error is not recoverable: exiting now
[root@static ~]#

a.n1
December 6th, 2020, 22:39
این ارور کسی داشته

ارور Failed to start PostgreSQL database server در centos 7

sarwhost
December 7th, 2020, 11:10
سلام
مطمئن باشید همه بسته ها رو به درستی نصب کردید راهنمای زیر رو هم مطالعه کنید


https://wiki.postgresql.org/wiki/YUM_Installation


این دستورات هم میتونه کمک کنه


vi /etc/yum.repos.d/CentOS-Base.repo
yum localinstall http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm
yum list postgres*
yum install -y postgresql95-server.x86_64 postgresql95-contrib.x86_64 postgresql95-libs.x86_64
/usr/pgsql-9.5/bin/postgresql95-setup initdb
systemctl enable postgresql-9.5.service
systemctl start postgresql-9.5.service


بعد از جرای دستور اخر systemctl status postgresql-9.5.service خروجی شبیه خروجی زیر باید باشه


postgresql-9.5.service - PostgreSQL 9.5 database server
Loaded: loaded (/usr/lib/systemd/system/postgresql-9.5.service; enabled)
Active: active (running) since Fri 2016-02-19 00:01:13 UTC; 6min ago
Process: 10809 ExecStart=/usr/pgsql-9.5/bin/pg_ctl start -D ${PGDATA} -s -w -t 300 (code=exited, status=0/SUCCESS)
Process: 10802 ExecStartPre=/usr/pgsql-9.5/bin/postgresql95-check-db-dir ${PGDATA} (code=exited, status=0/SUCCESS)
Main PID: 10811 (postgres)
CGroup: /system.slice/postgresql-9.5.service
├─10811 /usr/pgsql-9.5/bin/postgres -D /var/lib/pgsql/9.5/data
├─10812 postgres: logger process
├─10814 postgres: checkpointer process
├─10815 postgres: writer process
├─10816 postgres: wal writer process
├─10817 postgres: autovacuum launcher process
└─10818 postgres: stats collector process

a.n1
December 7th, 2020, 12:05
بادستورات بالا که گفتین هیچی نساخت و لاگ زیر داد


[root@static ~]# vi /etc/yum.repos.d/CentOS-Base.repo
[root@static ~]# yum localinstall http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm
Loaded plugins: fastestmirror
Cannot open: http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm. Skipping.
Nothing to do
[root@static ~]# yum list postgres*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.checkdomain.de
* extras: linux.darkpenguin.net
* updates: mirror.checkdomain.de
Available Packages
postgresql.i686 9.2.24-4.el7_8 base
postgresql.x86_64 9.2.24-4.el7_8 base
postgresql-contrib.x86_64 9.2.24-4.el7_8 base
postgresql-devel.i686 9.2.24-4.el7_8 base
postgresql-devel.x86_64 9.2.24-4.el7_8 base
postgresql-docs.x86_64 9.2.24-4.el7_8 base
postgresql-jdbc.noarch 9.2.1002-8.el7_8 updates
postgresql-jdbc-javadoc.noarch 9.2.1002-8.el7_8 updates
postgresql-libs.i686 9.2.24-4.el7_8 base
postgresql-libs.x86_64 9.2.24-4.el7_8 base
postgresql-odbc.x86_64 09.03.0100-2.el7 base
postgresql-plperl.x86_64 9.2.24-4.el7_8 base
postgresql-plpython.x86_64 9.2.24-4.el7_8 base
postgresql-pltcl.x86_64 9.2.24-4.el7_8 base
postgresql-server.x86_64 9.2.24-4.el7_8 base
postgresql-static.i686 9.2.24-4.el7_8 base
postgresql-static.x86_64 9.2.24-4.el7_8 base
postgresql-test.x86_64 9.2.24-4.el7_8 base
postgresql-upgrade.x86_64 9.2.24-4.el7_8 base
[root@static ~]# yum install -y postgresql95-server.x86_64 postgresql95-contrib.x86_64 postgresql95-libs.x86_64
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.checkdomain.de
* extras: linux.darkpenguin.net
* updates: mirror.checkdomain.de
No package postgresql95-server.x86_64 available.
No package postgresql95-contrib.x86_64 available.
No package postgresql95-libs.x86_64 available.
Error: Nothing to do
[root@static ~]# /usr/pgsql-9.5/bin/postgresql95-setup initdb
-bash: /usr/pgsql-9.5/bin/postgresql95-setup: No such file or directory
[root@static ~]# systemctl enable postgresql-9.5.service
Failed to execute operation: No such file or directory
[root@static ~]# systemctl enable postgresql-9.5.service
Failed to execute operation: No such file or directory
[root@static ~]# systemctl status postgresql-9.5.service
Unit postgresql-9.5.service could not be found.
[root@static ~]#

a.n1
December 7th, 2020, 18:55
موقع service postgresql start ارور زیر دریافت می کنم



[root@static ~]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xe" for details.

a.n1
December 9th, 2020, 10:39
موقع service postgresql start ارور زیر دریافت می کنم



[root@static ~]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xe" for details.

اساتید کسی این مشکل نداشته ؟

mahdy777
December 10th, 2020, 18:12
موقع service postgresql start ارور زیر دریافت می کنم



[root@static ~]# service postgresql start
Redirecting to /bin/systemctl start postgresql.service
Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and "journalctl -xe" for details.

بجای دستور بالا دستور زیر بزنید کفایت میکنه

service postgresql initdb