What is PostgreSQL?
PostgreSQL is an object-oriented database management system. It is based on POSTGRES, which was developed at the University of Berkeley. For an overview of all PostgreSQL features, please visit the official website https://www.postgresql.org/.
Creating a PostgreSQL database
On the main page of the PostgreSQl database manager, you will see your database list; it displays all the databases which currently exist. If you have not yet created any databases, you will only see the maximum number of allowable databases.
How to create a new PostgreSQL database:
- Click on "Add".
- On the following page, you will see the recommended (random) access details for your database. If you wish, you can change these.
- Select a name for the database as well as a name for the corresponding database user.
- The password provides access to the whole database and allows you to create, change, or delete any database information, column, or row.
- (Optional setting) Require SSL; this prohibits all unencrypted connections to the database. This can have a negative effect on the accessibility of the database.
- Click on Save to create the database.
- You should then see a message that you successfully created the database. Click on "PostgreSQL-Databases" to return to your database list.
Manage your database(s).
In the overview, you can create a new database or modify, delete, back up, and access existing databases via phpMyAdmin.
If you wish to delete a database, konsoleH will require you to confirm the deletion. Be careful when you confirm it; you cannot un-do the deletion.
Access your database via SSL
You can access your database in an encrypted manner using SSL. We can provide you with a ready-made certificate that you can use to carry out the encryption. Note: The speed of encrypted connections is slower.
The certificate is:
-----BEGIN CERTIFICATE-----
MIIG7jCCBNagAwIBAgIJAOHaB6/9NNBGMA0GCSqGSIb3DQEBCwUAMIGqMQswCQYD
VQQGEwJERTEPMA0GA1UECBMGQmF5ZXJuMRUwEwYDVQQHEwxHdW56ZW5oYXVzZW4x
GjAYBgNVBAoTEUhldHpuZXIgT25saW5lIEFHMRIwEAYDVQQLEwlEYXRhYmFzZXMx
GzAZBgNVBAMTEnNxbC55b3VyLXNlcnZlci5kZTEmMCQGCSqGSIb3DQEJARYXcm9v
dEBzcWwueW91ci1zZXJ2ZXIuZGUwHhcNMjIwNjA3MTYyOTUyWhcNMzIwNjA0MTYy
OTUyWjCBqjELMAkGA1UEBhMCREUxDzANBgNVBAgTBkJheWVybjEVMBMGA1UEBxMM
R3VuemVuaGF1c2VuMRowGAYDVQQKExFIZXR6bmVyIE9ubGluZSBBRzESMBAGA1UE
CxMJRGF0YWJhc2VzMRswGQYDVQQDExJzcWwueW91ci1zZXJ2ZXIuZGUxJjAkBgkq
hkiG9w0BCQEWF3Jvb3RAc3FsLnlvdXItc2VydmVyLmRlMIICIjANBgkqhkiG9w0B
AQEFAAOCAg8AMIICCgKCAgEAq1bzb3Mm4HlRNzf1xI1ssFIvaRjCu/ZpUYhh2Rk8
grexQWJ2ZNZtRqd8UPkIxGgJFuHbbfyf4N1QhC7uI/QqOf5VyPrE0WU75BBIvAhh
MH/xeBxvrrMHF/8yTg5RDS1heJ3Y5UzwSoVHvoNR8fOpcSQ1N3jHkSpZLNhUIky/
hSGdZMOaOUTk1IQbvCrvyIQB8QalCtc5fkg72PlX+ACeGfQGoM5jj+gyKfydQg6s
bPSatIxsKr7KcQxxsWRrV1BfROtxXDbDUwFDS18V7vEGzp7qQlyPLNvTVdH6Xk+U
eVT9I1TfTBq4nsVOjOaHUNC0QtRhTJpjyR/SE9MpRq0+d78LQ21wpYQNnB+ukjOK
TW4Slgr7Pk83cIGS5mJWDI786GiQ7LXFLrg3gyG1FiEATyDrfTrNkZQ9VRD/YSco
1pw84xUBwSwANKCrO+l4wFo8A7cSrYPQBpL/3RuxFap5BavX2MbuymK2MO2/8W0H
p8+wn5qnSt0BcrpeNV92UlBRaZHbnl+N/6oGXrt7lCScuRhIyHCftkEX/DQhwxvj
/lIWMWQTyceqQl9QLI7UkxcXsL7NoalO83CH6BP905mZs+PCL9DPagyMceKOLSwm
mWt05OIAECbqUotCqtLZhHcTB1Nnlqi/4VJiASEStzs7hkhCAZmaTkV0+X7quiQJ
l3MCAwEAAaOCARMwggEPMAwGA1UdEwQFMAMBAf8wHQYDVR0OBBYEFCf95RRu/ZgZ
iZIyQCLn7SKJFJFoMIHfBgNVHSMEgdcwgdSAFCf95RRu/ZgZiZIyQCLn7SKJFJFo
oYGwpIGtMIGqMQswCQYDVQQGEwJERTEPMA0GA1UECBMGQmF5ZXJuMRUwEwYDVQQH
EwxHdW56ZW5oYXVzZW4xGjAYBgNVBAoTEUhldHpuZXIgT25saW5lIEFHMRIwEAYD
VQQLEwlEYXRhYmFzZXMxGzAZBgNVBAMTEnNxbC55b3VyLXNlcnZlci5kZTEmMCQG
CSqGSIb3DQEJARYXcm9vdEBzcWwueW91ci1zZXJ2ZXIuZGWCCQDh2gev/TTQRjAN
BgkqhkiG9w0BAQsFAAOCAgEAYNs1ptU+SjBeDMtZY1gXUkoMYN/ujsNwLp64Si2z
De/md+XxQtN01t14MJn7yWdfPudl3WS3b4S9cXx5koLqjPBDk25R2Yb/klcj5AU7
H7bfPR/mHIj/1Xc3US6sEIE1oU3pjQvm6iYWuhKV41CQQAEGdjCS8Y4Y36aaNTB/
4NL4t8ZHE4JKuDHWYUArQcvubPt5yGjkspoFVPlV4ktkw+W2hjBvwCNflE+s8zKl
qEJy+izsxl6+tIz8UXK7++ocBZP4Wxc/GlZQ2g3NWWLMpK0r+4G1MKUs8f5yWsaL
Sswhs15rnN07X9DKbsmZboc0DT8QVqUYl5ErO/baG3Fd3cwk9vUJRDlCeHWKAQDM
Ne6171VKMBVcjd3u9IqL17j2JughrfelH5SfkX7VJnkcS7Gaf2ppJeyedgngLE3A
BeFDhAJ9rQdSAXAzeZC5/6YotR5tDaumYgWtGu5biNocY+f0OHNsuBjjQcIBC7MV
zZ5XET75IaY2LCbTz58a3KrImyYGjKt+WzGfemWHVx9TC6ZOmVXSuPzTevQvpY5q
Wgx7nM25JCPXjhtwS7uBQ+QDhlITYgwgMPyDzzEFUDAblInqgUnj3VfVLTQPx+sL
MZb5eNEJ0316JCcgZJ8HZ+iUL/QjFewpOL+MlMqvUbfLh9jT04BXzSFLT8Cry1Wb
X40=
-----END CERTIFICATE-----You can save the certificate locally as a text file (for example, as "sqlca.pem"). Once you have done that, you can make an encrypted connection. Unfortunately, however, it is not possible for you to use your own client certificates.
Example commands for encrypted access to PostgreSQL
- PostgreSQL command line (CLI)
psql -h HOSTNAME -U USERNAME -d DBNAME -W --set=sslmode=verify-full --set=sslrootcert=[PFAD]/sqlca.pem
- PHP (PDO)
$pdo = new PDO('pgsql:host=HOSTNAME;dbname=DBNAME;sslmode=verify-full;sslrootcert=[PFAD]/sqlca.pem;', 'USERNAME', 'PASSWORD');
Is there also phpMyAdmin for PostgreSQL?
phpMyAdmin is written for MySQL and does not support PostgreSQL. However, there is a web-based application for PostgreSQL which is very similar to phpMyAdmin. You can download it at http://phppgadmin.sourceforge.net/. Install the tool on your account and follow the operating instructions to manage your PostgreSQL databases.