theCAT
  
Report a Problem:
Email: support@cat.pdx.edu
Phone: 503-725-5420
Location: FAB 82-01
  USERS PLATFORMS SYSTEM RESOURCES    
Home Students Fac/Staff CS Tutors Guidelines Windows Linux Mac Mail Network Software Web TheCAT Sitemap Contact
arrowHome arrow Web arrow Database Services arrow Connect to PostgreSQL Thursday, 30 March 2017  
Database Services
Connect to PostgreSQL Print
Written by benzer   
Monday, 11 February 2013

How to access PostgreSQL from a Web Browser

You can access PostgreSQL from anywhere - on campus, on a laptop, or at home - using this link:

https://web.cecs.pdx.edu/

When you go to the webpage you will be prompted for your username and password. The username will always be your MCECS username, and the password will be provided to you when you activate your account. You cannot change your password using a button or link on the web site; you will need to use an SQL statement

Access PostgreSQL using the Unix/Linux command line

Use this command to access PostgreSQL from the Unix/Linux command line:

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.

Access PostgreSQL from a PostgreSQL client

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
Last Updated ( Tuesday, 08 March 2016 )

©1999 - 2017 TheCAT