Hello, I'm new to managing databases and need to use uuid-ossp extension but I'm not sure how to do this.

Using CentOS Linux release 7.8.2003 (Core)
I installed PostgreSQL Manager then PgSQL version 11.0.
After that I installed the postgresql-contrib to the system with yum install postgresql-contrib in order to have uuid-ossp extension available.

Then I created a database uuidtest.
Using the ssh from files, I did the following:
logged in as postgres to psql: sudo -i -u postgres,
SELECT * FROM pg_available_extensions;
All I got was this:
plpgsql | 1.0 | 1.0 | PL/pgSQL procedural language

So I decided to copy the files from the /usr/share/pgsql/extension to /www/server/pgsql/share/extension

Then I run the SELECT * FROM pg_available_extensions; again and everything was there.

From there I thought I would be able to install the extension so I selected the schema I need it to be active: \c uuidtest and ran the create extension command.

I got this error:
uuidtest=# CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
ERROR: could not access file "$libdir/uuid-ossp": No such file or directory

I also copied the libuuid.so: cp /usr/lib64/libuuid.so* /www/server/pgsql/lib/, but it didn't work either.

How can I fix this?

    Facing the same problem. It looks like the installation script should include postgres-citex while installing postgres.

    The author needs to confirm this

      need to create the database again for it to take effect? i need to install uuid-ossp and Postgis

        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.

        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.

          Obara
          Have you executed this command?
          yum install uuid-devel -y

          if possible, i can login your panel to check jose@aaPanel_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?

                  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

                      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

                        aaPanel_Kern

                        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

                            a year later