Problem
...
I need to connect to a Spinup
...
PostgreSQL database
...
Solution
Panel | ||
---|---|---|
| ||
There are a number of clients you may use to connect to a Spinup PostgreSQL database (see https://wiki.postgresql.org/wiki/PostgreSQL_Clients). From a machine with the psql client installed, you may just type: Note that the default database is called postgres - once you connect initially you can create additional ones. E.g. the connection may look like this: After clicking enter, you will be asked for the password (the one given when creating the database - which you can reset at any time). That's it! - At this point you have full administrator rights on the database and can create or drop tables, add or delete data, etc. Note: When connecting to the database always use SSL encryption. If you use the psql client this is done automatically but when connecting from an application you may need to explicitly enable encryption. |
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...