Enhancing NAS experience - The Community Package Hub is all about quality software, made for your Synology NAS. Collected from all over the world, reviewed and compliant to official requirements. Delivering thousands of packages to users every month ... become one of them today.

App details

package icon phpPgAdmin
Publisher: Nigel Barnes
Version: 5.1.0-002 Firmware: 5.0-4371 and onward
Last update: 31/03/2014 Size: 829.44 Kb
Architecture: all
required packages: none
Description:
phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server. It handles all the basic functionality as well as some advanced features such as triggers, views and functions. Manage the PostgreSQL databases stored on your DiskStation by installing this package.
Changelog:
Version 5.1.0-002 - 31/03/2014
- Updated phpPgAdmin to version 5.1.
- Removed Web Station check.
- Updated icons.

Version 5.0.4-001 - 12/11/2012
- Initial package release.

 Screenshots (1)
 Comments (33)
Page  1  2  3 
  1. Martin Uk wrote on Dec 12, 2017 at 09:48 PM

    Is there a fit-for 2018 set of instructions for this, for the DS415+ using DSM 6.14 version 15217 Update 2

    Needless to say I've tried the above method and it does not work. Not only does it not work but it also messes up PhotoStation too.

    Reply

  2. Sam wrote on Jun 09, 2016 at 11:47 AM

    Hi,
    I just install your package on my DS415+, with DSM 6, and I have "404 error" when I click on software.
    I try to modify files in comments (like /usr/syno/synoman/phpsrc/phpPgAdmin/conf/config.inc.php) but I think links are changed.
    Furthermore, I think the real problem comes from no links between "web station" and phppgadmin (like a link between /web/phppgadmin and the directory or creating a virtualhost - but I don't find your install directory).
    Thanks

    Reply

    1. Sam wrote on Jun 09, 2016 at 11:47 AM - Unapproved

      Hi,
      I just install your package on my DS415+, with DSM 6, and I have "404 error" when I click on software.
      I try to modify files in comments (like /usr/syno/synoman/phpsrc/phpPgAdmin/conf/config.inc.php) but I think links are changed.
      Furthermore, I think the real problem comes from no links between "web station" and phppgadmin (like a link between /web/phppgadmin and the directory or creating a virtualhost - but I don't find your install directory).
      Thanks

      1. Sam wrote on Jun 09, 2016 at 11:47 AM - Unapproved

        Hi,
        I just install your package on my DS415+, with DSM 6, and I have "404 error" when I click on software.
        I try to modify files in comments (like /usr/syno/synoman/phpsrc/phpPgAdmin/conf/config.inc.php) but I think links are changed.
        Furthermore, I think the real problem comes from no links between "web station" and phppgadmin (like a link between /web/phppgadmin and the directory or creating a virtualhost - but I don't find your install directory).
        Thanks

        1. Sam wrote on Jun 09, 2016 at 11:47 AM - Unapproved

          Hi,
          I just install your package on my DS415+, with DSM 6, and I have "404 error" when I click on software.
          I try to modify files in comments (like /usr/syno/synoman/phpsrc/phpPgAdmin/conf/config.inc.php) but I think links are changed.
          Furthermore, I think the real problem comes from no links between "web station" and phppgadmin (like a link between /web/phppgadmin and the directory or creating a virtualhost - but I don't find your install directory).
          Thanks

          1. Sam wrote on Jun 09, 2016 at 11:47 AM - Unapproved

            Hi,
            I just install your package on my DS415+, with DSM 6, and I have "404 error" when I click on software.
            I try to modify files in comments (like /usr/syno/synoman/phpsrc/phpPgAdmin/conf/config.inc.php) but I think links are changed.
            Furthermore, I think the real problem comes from no links between "web station" and phppgadmin (like a link between /web/phppgadmin and the directory or creating a virtualhost - but I don't find your install directory).
            Thanks

            1. Sigi wrote on Jan 09, 2017 at 03:39 PM

              In addition I installed Photo Station and then it worked.

          2. Dominique wrote on Oct 31, 2016 at 07:23 AM

            Hello,

            I just follow the procedure you suggest (even 3 times to be sure I did not make any mistake, I still cannot connect.

            I am on a NAS 1515+ / DSM 6.0.2-8451 Update 2

            Any idea ?

            HAve a nice day

            Reply

        2. enzolino wrote on Oct 16, 2016 at 06:35 PM

          Thanks Yiannis! Just wrote your instruction down, so it's fast.

          Login to Putty as admin. Get permanent sudo
          sudo -i

          create folder:
          mkdir /usr/syno/synoman/phpsrc

          download and install in DSM6.x:
          PhpPgAdmin

          Create file:
          vi /usr/local/etc/nginx/conf.d/www.phppgadmin.conf

          Instert:

          location ~ ^/phpPgAdmin/ {
          fastcgi_read_timeout 300;
          root /usr/syno/synoman/phpsrc;
          location ~ ^/phpPgAdmin/(.*)/\. {
          deny all;
          }
          location ~* \.(jpg|jpeg|png|gif|css|js|ico)$ {
          expires max;
          log_not_found off;
          }

          location ~* \.php(/|$) {
          include fastcgi.conf;
          fastcgi_pass unix:/run/php-fpm/php56-fpm.sock;
          fastcgi_index index.php;
          }
          }
          location = /phpPgAdmin {
          fastcgi_read_timeout 300;
          root /usr/syno/synoman/phpsrc;
          try_files $uri/ /phpPgAdmin/index.php$is_args$args;
          }


          alter rights:
          chmod 755 /usr/local/etc/nginx/conf.d/www.phppgadmin.conf

          reload nginx:
          nginx -s reload

          vi /usr/local/etc/php56/conf.d/user-settings.ini

          add after ".....home"
          ::/usr/syno/synoman/phpsrc/phpPgAdmin

          "Esc" :wq

          reboot synology

          login to putty and get permanent sudo:
          sudo -i

          login postgres:
          su - postgres
          psql

          list user and roles:
          \du

          create admin user in postgres:
          CREATE USER admin PASSWORD 'xyz';
          ALTER USER admin WITH SUPERUSER;
          ALTER USER admin WITH CREATEDB;
          ALTER USER admin WITH CREATEROLE;
          \du

          add 'localhost# to phppgadmin:
          cd /usr/syno/synoman/phpsrc/phpPgAdmin/conf
          vi config.inc.php

          change the line: $conf['servers'][0]['host'] = '';
          to: $conf['servers'][0]['host'] = 'localhost';

          change extra_login_security to false:
          $conf['extra_login_security'] = false;

          Exit with :wq

          vi /etc/postgresql/pg_hba.conf

          i for insert:
          host all admin 127.0.0.1/32 trust

          you should be able to login now. if not restart phpPgAdmin in DSM

          Reply

      2. Yiannis wrote on Aug 11, 2016 at 11:08 AM

        Hi Jonathan,

        I have manage to modify PhpPgAdmin in order to work on DSM-6 and with nginx (replaced apache on newer DSM versions).

        Some people using "Web Station" to make PhpPgAdmin work.
        I think that a native way is more preferable.

        Just created a youtube video for this. Hope this helps.......

        https://youtu.be/2z8lSlh3xBw

        Yiannis

        Reply

    2. Jonathan Mack wrote on Mar 26, 2016 at 10:40 AM

      Jerry,

      Any chance you can post some steps on how you accomplished it? I'm sure myself and a few others would really appreciate it.

      Kind Regard

      JM

      Reply

  3. Jerry wrote on Mar 26, 2016 at 02:25 AM

    Hi, I upgraded to dms 6.0 this morning. The upgrade deleted most of the phppgadmin files. I had to
    Delete and re-install the app.

    In addition I had to learn how to configure httpd to point to the appropriate directory and set
    Directory access permissions.

    It appears to be working at this point in time...

    Reply

  4. Jonathan Mack wrote on Mar 25, 2016 at 04:00 PM

    Further note,

    With the new DSM 6.0 you can no longer access telnet with the username:root listed in the below steps. This is due to the DSM 6.0 recent update "Root account is replaced by administrators group credentials to log into SSH to enhance security." You will now need to telnet with your admin username and password. If you wish to use root you can always log in using your admin username and password and use "sudo su -" followed by the admin password once again. This will put you back under the root user. I presume this recent update is causing some issues with this package.

    KR
    JM

    Reply

  5. Jonathan Mack wrote on Mar 25, 2016 at 03:50 PM

    Hey all,

    I have been running phpPgAdmin for months with no issues. I upgraded to DSM 6.0-7321 last night on my DS1513+. Since the upgrade last night I now seem to be getting a 404 page cannot be found error when trying to access the phpPgAdmin page from localhost. I am also unable to connect to any of the databases from clients.

    I have attempted numerous things to try and resolve the issue with no avail;

    Rebooted DM.
    Ensured both ports 80 and 5432 are open. (also tried disabling firewall for test purposes)
    Reinstalled both Init 3rdparty and phpPgAdmin with the latest versions.
    Followed both the instructions from enzolino and Can using Telnet.
    I have also checked the pg_hba.conf file to ensure that localhost was trusted.

    I feel like a beaten man! Has anyone got this working on DSM6.0 and if another can assist it would be appreciated.

    JM

    Reply

  6. Tirias wrote on Apr 29, 2015 at 11:13 AM

    Hi

    i have just installed the package and it has been installed correctly. But when i try to access remotely
    like http://mysynology.myds.me/phpgadmin it says page not found...

    What can be the issue here?

    Thanks in advance

    Reply

  7. Oliver wrote on Mar 13, 2015 at 11:32 PM

    I installed it on my Synology with DSM 5.1-5022.
    Everything works fine. I can now see the entries for audio-station, video-station,... GREAT!
    thx.

    Reply

  8. Ivan Adrian wrote on Mar 06, 2015 at 01:38 PM

    Hello,
    I have installed this aplication but i can not log in!
    I have used admin credentials bit no chance!
    Thank you!

    Reply

    1. Ivan Adrian wrote on Mar 06, 2015 at 01:38 PM - Unapproved

      Hello,
      I have installed this aplication but i can not log in!
      I have used admin credentials bit no chance!
      Thank you!

      1. Ivan Adrian wrote on Mar 06, 2015 at 01:38 PM - Unapproved

        Hello,
        I have installed this aplication but i can not log in!
        I have used admin credentials bit no chance!
        Thank you!

        1. Can wrote on May 21, 2015 at 01:00 AM

          After doing what enzolino says above before typing any exit on ssh terminal
          open the config file with the command below

          vi /usr/syno/synoman/phpsrc/phpPgAdmin/conf/config.inc.php
          pressing i key puts you into edit mode
          change this
          $conf['servers'][0]['host'] = '';
          to this
          $conf['servers'][0]['host'] = 'localhost';

          and this
          $conf['extra_login_security'] = true;
          to this
          $conf['extra_login_security'] = false;

          then press escape button once
          type :wq

          and exit, exit of course

          Reply

      2. enzolino wrote on May 19, 2015 at 09:57 PM

        for some unknown reason the user 'admin' does not exists sometimes in postgres. so you have to login with the Putty first and create te user 'admin' as follows:
        login as username 'root' and use the admin password
        su - postgres
        psql
        \du
        CREATE USER admin PASSWORD 'xyz';
        ALTER USER admin WITH SUPERUSER;
        ALTER USER admin WITH CREATEDB;
        ALTER USER admin WITH CREATEROLE;
        \du
        \q
        exit
        exit

        Reply

    2. Tirias wrote on Apr 29, 2015 at 11:17 AM

      Same problem here... do you finally realise how to solve it?

      Reply

      1. Pernod wrote on Dec 16, 2014 at 12:35 PM

        Everything works fine on my 412+. The username/password are your DS admin credentials.

        Reply

    3. Andrew wrote on Dec 12, 2014 at 09:29 PM

      I was able to install the package fine on 412 running DSM 5.1 - I can view the page /ip/phpPgAdmin/ but I cannot figure out the username and password? Is their configuration that isn't obviously mentioned? Most of the information I can find online seems to be from 2008 and none of it seems to help me. I could really use some help. Thanks!

      Reply

    4. Alain wrote on Dec 12, 2014 at 06:58 PM

      Same on my DS412 DSM 5.1 :((

      Reply

    5. murales wrote on Nov 30, 2014 at 10:04 PM

      Same problem here...no clue!

      Reply

  9. Simone wrote on Nov 25, 2014 at 03:55 PM

    Since the recent DSM 5.1 phppgadmin doesn't seem to work anymore on my DS212+
    The package installs and is reported running correctly but opening it shows a "Sorry, the page you are looking for is not found" synology error page

    pg_hba.conf seems to be in order: trust local, trust host 127.0.0.1

    What could be causing the problem?

    Reply

  10. Mane wrote on Aug 19, 2014 at 10:30 AM

    I need a usable instruction, how can I install a Postgresql on Synology? (DS 713+, OS. 5 Update 3, PC: windows 7) I wanted to use NAS only for Postgresql server.

    Thanks in advance!

    Regards,

    Mane

    Reply

Page  1  2  3 





Allowed tags: <b><i><br>Add a new comment: