Doc tools: Log in
You can create one or more PostgreSQL databases in UCC.
The first database you create will have the same name as your username. Subsequent databases will be prefixed with "username_".
psql -h pgsql.ulyssis.org
You can connect to the database with the following details:
Note that some CMSs will assume that you use "localhost" as the host, and will hide the host option under advanced settings in the installation process. If you can't find anywhere to enter the hostname, look under advanced settings.
If you are programming your application yourself, PostgreSQL often uses the following connection format:
host=$host user=$username password=$password db=$dbname
Where you replace the parts starting with
$ with the above connection details.
If you are using PHP's pg_connect to connect to the database, and your username is "foo", your password is "password" and your database name is "foo":
$connection = pg_connect("host=pgsql.ulyssis.org user=foo password=password db=foo");
If you want to connect using PDO, your username is "foo", your password is "password" and your database is "foo":
$pdo = new PDO('pgsql:host=pgsql.ulyssis.org;dbname=foo', 'foo', 'password');
To prevent unnecessary load on our database server by hackers and bots it is only available inside of our network. If you wish to access it externally the easiest way is to use an SSH-tunnel. On Linux, Mac OSX and other Unix-like Operating Systems it is easily possible to use the following command to create a tunnel to a local port (in this case 5400):
ssh firstname.lastname@example.org -L 5400:pgsql.ulyssis.org:5432 -N
You can use "ssh -f email@example.com -L 3300:mysql.ulyssis.org:3306 -N": the f-argument will put the command in the background.
If necessary for an application or website you wish to use on ULYSSIS, we can always enable PostGIS for the specific database you wish to use it on. Contact us at firstname.lastname@example.org and let us know you would like to get PostGIS enabled and on which specific database.