You can access PostgreSQL using our web interface from anywhere – on campus, on a laptop, or at home – using this link:

https://dbase.cecs.pdx.edu/postgresql/

NOTE: First, you will be prompted to use your MCECS account login/password to authenticate with this web page.

Once you get through to the webpage, you will be prompted for your database username and password. The username will always be your MCECS username, and the password will be provided to you when you activate your database account. (This is not the same as your regular MCECS account credentials that you use to login to MCECS computers. Your database account is maintained separately.) You cannot change your password using a button or link on the web site; you will need to use an SQL statement.

Use this command to access PostgreSQL from the Unix/Linux command line on an MCECS system:

psql -h db.cecs.pdx.edu -U username databasename

‘psql’ is the program name, the ‘-h’ means host, and our host is db.cecs.pdx.edu, which is our database server. Next is your MCECS username, specified after the ‘-U’. Last is your database name, which is also your MCECS username. You will be automatically prompted for your password.

Note that direct access to the MySQL server requires the use of a VPN.

You can access your PostgreSQL database using a client you install on your personal computer. These programs will need some information about our server in order to access your database.

Username: cecs username
Database: also your cecs username
Password: given to you when you make your PostgreSQL account
Hostname: db.cecs.pdx.edu
Port: 5432 is the default port for PostgreSQL

You can change your PostgresSQL password through the command line on an MCECS Linux system with the following command

ALTER USER $mcecs_username WITH PASSWORD ‘$new_password’;

Replace $mcecs_username with your MCECS login name and $new_password with the new password. You must also include the quotation marks.

If you have forgotten your PostgresSQL password and need to reset it , you will need to contact the CAT for further assistance.