Change a Password for PostgreSQL on Linux via Command Line

Posted on by Justin Palmer
Category: Technical Support, Tutorials | Tags: , , , , , , , , , , ,
Reading Time: < 1 minutePostgreSQL supports many client authentication methods, but in this case we’re only going to concern ourselves with two: password and md5.
Note: The default authentication method for PostgreSQL is ident. If you’d like to change the PostgreSQL authentication method from ident to md5, then visit the linked tutorial!
Continue reading “Change a Password for PostgreSQL on Linux via Command Line” →

Related Articles:

Install and Connect to PostgreSQL 10 on Ubuntu 16.04

Posted on by Justin Palmer
Category: Series | Tags: , , ,
Reading Time: < 1 minute

PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems. Its object-relational meaning that you’ll be able to use objects, classes database schemas and in the query language.  In this tutorial, we will show you how to install and connect to your PostgreSQL database on Ubuntu 16.04.

 

Continue reading “Install and Connect to PostgreSQL 10 on Ubuntu 16.04” →

Related Articles:

How To Install and Connect to PostgreSQL on Fedora 23

Posted on by dpepper | Updated:
Category: Tutorials | Tags: ,
Reading Time: 2 minutesPostgreSQL is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It often is used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions. Continue reading “How To Install and Connect to PostgreSQL on Fedora 23” →

Related Articles:

Change PostgreSQL Authentication Method from Ident to MD5

Posted on by J. Mays | Updated:
Category: Technical Support, Tutorials | Tags: , , , , , , , , , , ,
Reading Time: 2 minutesPostgreSQL supports multiple client authentication methods including: trust, reject, md5, password, gss, sspi, krb5, ident, peer, ldap, radius, cert, and pam. Here we’re only going to concern ourselves with two: ident and md5. Continue reading “Change PostgreSQL Authentication Method from Ident to MD5” →

Related Articles:

What is the Default Password for PostgreSQL?

Posted on by J. Mays | Updated:
Category: Getting Started, Tutorials | Tags: , , , , , , , , ,
Reading Time: < 1 minuteWhen connecting to PostgreSQL on Linux for the first time many admins have questions, especially if those admins are from the MySQL world. By default, when PostgreSQL is installed, a postgres user is also added. If you run the command: cat /etc/passwd … you’ll see the postgres user. Continue reading “What is the Default Password for PostgreSQL?” →

Related Articles:

How to Install and Connect to PostgreSQL on Fedora 22

Posted on by J. Mays | Updated:
Category: Technical Support, Tutorials | Tags: , , , , , ,
Reading Time: < 1 minutePostgreSQL (pronounced ‘post-gres-Q-L’) is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It is often used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions.

Pre-Flight Check

  • These instructions are intended specifically for installing PostgreSQL on Fedora 22.
  • I’ll be working from a Liquid Web Self Managed Fedora 22 server, and I’ll be logged in as root.
Continue reading “How to Install and Connect to PostgreSQL on Fedora 22” →

Related Articles:

How to Install and Connect to PostgreSQL on Fedora 21

Posted on by J. Mays | Updated:
Category: Technical Support, Tutorials | Tags: , , , , , ,
Reading Time: < 1 minutePostgreSQL (pronounced ‘post-gres-Q-L’) is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It is often used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions.

Pre-Flight Check

  • These instructions are intended specifically for installing PostgreSQL on Fedora 21.
  • I’ll be working from a Liquid Web Self Managed Fedora 21 server, and I’ll be logged in as root.
Continue reading “How to Install and Connect to PostgreSQL on Fedora 21” →

Related Articles:

How to Install and Connect to PostgreSQL on Fedora 20

Posted on by J. Mays | Updated:
Category: Technical Support | Tags: , , , , , ,
Reading Time: < 1 minutePostgreSQL (pronounced ‘post-gres-Q-L’) is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It is commonly used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions.
Pre-Flight Check
  • These instructions are intended specifically for installing PostgreSQL on Fedora 20.
  • I’ll be working from a Liquid Web Self Managed Fedora 20 server, and I’ll be logged in as root.
Continue reading “How to Install and Connect to PostgreSQL on Fedora 20” →

Related Articles:

How to Install and Connect to PostgreSQL on CentOS 7

Posted on by J. Mays | Updated:
Category: Technical Support | Tags: , , , , , ,
Reading Time: < 1 minutePostgreSQL (pronounced ‘post-gres-Q-L’) is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It is commonly used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions.
Pre-Flight Check
  • These instructions are intended specifically for installing PostgreSQL on CentOS 7.
  • I’ll be working from a Liquid Web Self Managed CentOS 7 server, and I’ll be logged in as root.
Continue reading “How to Install and Connect to PostgreSQL on CentOS 7” →

Related Articles:

How to Install and Connect to PostgreSQL on CentOS 6

Posted on by J. Mays | Updated:
Category: Technical Support | Tags: , , , ,
Reading Time: < 1 minutePostgreSQL (pronounced ‘post-gres-Q-L’) is a free, open-source object-relational database management system (object-RDBMS), similar to MySQL, and is standards-compliant and extensible. It is commonly used as a back-end for web and mobile applications. PostgreSQL, or ‘Postgres’ as it is nicknamed, adopts the ANSI/ISO SQL standards together, with the revisions.
Pre-Flight Check
  • These instructions are intended specifically for installing PostgreSQL on CentOS 6.
  • I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
Continue reading “How to Install and Connect to PostgreSQL on CentOS 6” →

Related Articles: