openSUSE Build Service

Overview Repositories Revisions Requests Users Attributes Meta

File README.SUSE of Package pgadmin4 (Revision 2ac145577237bfb5bc59a2c1a83958df)

Currently displaying revision 2ac145577237bfb5bc59a2c1a83958df , Show latest

1. Install the postgresql server and configure it.
   If you already have a postgresql instance you can skip this step.

First, we have to install the postgresql server with:

sudo zypper in postgresql10-server

Then we start the server:

sudo rcpostgresql start

And then we have to add login credentials for the user postgres with:

sudo -u postgres psql postgres

This will open the psql client where you have to type:

\password postgres

It will ask for the password and then once again to confirm it. You can exit psql by typing '\q'

Now we'll make sure postgresql allows users to login by asking for the
   password. Edit the /var/lib/pgsql/data/pg_hba.conf file as root and replace
   the "ident" authentication method by "md5", like this:

host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5

Of course, if users need to log in from other hosts, use the proper network masks.

Now, let's restart the server so the new configuration is used:

sudo rcpostgresql restart

2. Start pgAdmin4 ("Management tool for PostgreSQL (pgAdmin 4)") which you can
   find in the Office menu in your desktop. This will open pgadmin4 in your
   default browser and an icon in your system tray which can be used to open
   more windows or shut pgadmin down.

3. In pgAdmin, click on "Add New Server" . Set a name for the server connection,
   go to the "Connection" tab and set the connection information . If you're
   using a postgresql instance in the same host, you can use:
   Hostname: localhost
   Password: the password of the postgres user.

Click on "Save" to store the new server configuration.

4. The server should appear in the left pane.

Places

File README.SUSE of Package pgadmin4 (Revision 2ac145577237bfb5bc59a2c1a83958df)

Places