- Edited
need to create the database again for it to take effect? i need to install uuid-ossp and Postgis
PostgreSQL Extensions
- Edited
I made the changes:
Then installed the Postgresql 11.0 again
I got this error:
After the installation finishes, it says the installation was successful but the installation button changes to chinese text and the postgres was not installed.
I just noticed the typo in the file edit, I'll keep it for future reference of this fail success bug.
- Edited
Now with the correct name in the pgsql_install.sh
Postgresql 11.0 installation is successful but the service won't start.
Log tab:
-bash: /www/server/pgsql/bin/postgres: No such file or directory
-bash: /www/server/pgsql/bin/postgres: No such file or directory
-bash: /www/server/pgsql/bin/postgres: No such file or directory
-bash: /www/server/pgsql/bin/postgres: No such file or directory
2020-07-24 00:29:19.845 GMT [25006] LOG: skipping missing configuration file "/www/server/pgsql/data/postgresql.auto.conf"
2020-07-24 00:29:19.846 GMT [25006] FATAL: "/www/server/pgsql/data" is not a valid data directory
2020-07-24 00:29:19.846 GMT [25006] DETAIL: File "/www/server/pgsql/data/PG_VERSION" is missing.
2020-07-24 00:31:17.360 GMT [25499] LOG: skipping missing configuration file "/www/server/pgsql/data/postgresql.auto.conf"
2020-07-24 00:31:17.361 GMT [25499] FATAL: "/www/server/pgsql/data" is not a valid data directory
2020-07-24 00:31:17.361 GMT [25499] DETAIL: File "/www/server/pgsql/data/PG_VERSION" is missing.Removing the parameters--with-uuid=ossp, the installation is successful and everything works fine.
- Edited
Obara
Have you executed this command?
yum install uuid-devel -y
if possible, i can login your panel to check jose@aaPanel_Jose
Yes uuid-devel was installed
aaPanel_Jose if possible, i can login your panel to check jose@aaPanel_Jose
I'd always rather do it myself than get help for learning purposes, but if you think it's necessary I'll give you access. Is that your e-mail?
Mainly because every time I want to see your screenshot, it can’t be displayed. My email is jose@aapanel.com
2 years later
andre Hi, I have installed PostgreSQL Manager and DB Postgresql 14.2. Now I need to install the Postgis extension. Can you please guide me on how did you install PostGIS on aaPanel? I am running Ubuntu 20.04 on Hyper-V
6 months later
System: CentOS 7.9.2009 x86_64(Py3.7.9
php: 8.1.17
PgSQL Version: postgresql 14.2
Hello, how can I install the following two extensions?
PgSQL, PDO-PgSQL
aaP_pfalzgraf_gyula
Hi, try to install manually
cd /www/server/panel/install && /bin/bash install_soft.sh 1 install pdo_pgsql 81
- Edited
Hello, what could be wrong?
selecting download node...
php-8.1 已安装过pdo_pgsql,请选择其它版本!
php-8.1 not install, Plese select other version!
2023-07-06 17:39:47 (25.6 MB/s) - ‘pdo_pgsql.sh’ saved [4039/4039]
selecting download node...
PHP: syntax error, unexpected '=' in /www/server/php/81/etc/php-cli.ini on line 1777
PHP Warning: Invalid "opcache.jit" setting. Should be "disable", "on", "off", " tracing", "function" or 4-digit number in Unknown on line 0
Reload service php-fpm done
Hello, try to delete the configuration information of the relevant extension in the configuration
Deleting and reinstalling php81 solved the problem, but when I try to make a Backup, I get the following error.
========
127: Command not found
Output
Error Output
sh: pg_dump: command not found
Hello, it is recommended that you intercept more information, unable to determine what the problem is
a year later
aaPanel_Jose
I have followed your instructions. Is there a next step? Because I am still encountering the same error with uuid-ossp.
Hello, try to install the extension by referring to this post.
https://www.aapanel.com/forum/d/19374-postgresql-extensions/2