Home
Wellsite Services
GIS and Software Development
News
Contact

Menu

Contact

Please don’t hesitate to send us a message 24 hours a day or contact us at +1 (587)-576-6736.

Your Name (required)

Your Email (required)

Subject

Your Message

Δ

News

Creating user groups in PostgreSQL

Posted on April 12, 2019May 6, 2019 by Tyler Pubben

In larger work environments it becomes essential to be able to assign similar permissions to groups of people for the database environment. PostgreSQL has a built in authentication system that easily allows for this. As with the rest of this documentation, this section assumes a PostgreSQL installation on a Debian based Linux distribution. We use […]

Logging in to PostgreSQL database on Linux terminal

Posted on April 11, 2019May 6, 2019 by Tyler Pubben

This section assumes command line access to the PostgreSQL server from a terminal window. The server used in this section is running Ubuntu Linux 18.10. To Log into your user account in the database: psql -U <postgre username> -d <dbname> Logging in to root PostgreSQL user account If you are the database administrator and need […]

Changing user access permissions on PostgreSQL schemas

Posted on April 11, 2019May 6, 2019 by Tyler Pubben

This section assumes command line access to the PostgreSQL server from a terminal window. The server used in this section is running Ubuntu Linux 18.10. Once logged into the terminal either locally or over SSH, log in as the root database user “postgres” by typing: sudo -i -u postgres Or if you don’t have access […]

Post navigation

« Previous 1 2 3 4 5 6 7 8 Next »

Copyright 2021 Silver Spring Energy Consulting Ltd.