postgresql

missing FROM-clause entry for table

by

You typically only use an alias for a table name when you need to prefix a column with the table name due to duplicate column names in the joined tables and the table name is long or when the table is joined to itself. In your case you use an alias for VCustomer but only use it … Read more

fe_sendauth: no password supplied

by

After making changes to the pg_hba.conf or postgresql.conf files, the cluster needs to be reloaded to pick up the changes. From the command line: pg_ctl reload From within a db (as superuser): select pg_reload_conf(); From PGAdmin: right-click db name, select “Reload Configuration” Note: the reload is not sufficient for changes like enabling archiving, changing shared_buffers, etc — those require a cluster restart.

PSQLException: current transaction is aborted, commands ignored until end of transaction block

by

I got this error using Java and PostgreSQL doing an insert on a table. I will illustrate how you can reproduce this error: Summary: The reason you get this error is because you have entered a transaction and one of your SQL Queries failed, and you gobbled up that failure and ignored it. But that … Read more

Postgresql 9.2 pg_dump version mismatch

by

You can either install PostgreSQL 9.2.1 in the pg_dump client machine or just copy the $PGHOME from the PostgreSQL server machine to the client machine. Note that there is no need to initdb a new cluster in the client machine. After you have finished installing the 9.2.1 software, remember to edit some environment variables in your .bash_profile file.

“use database_name” command in PostgreSQL

by

When you get a connection to PostgreSQL it is always to a particular database. To access a different database, you must get a new connection. Using \c in psql closes the old connection and acquires a new one, using the specified database and/or credentials. You get a whole new back-end process and everything.

What is the default password for Postgres

by

WARNING: trust means exactly that. Anyone who can connect to the PostgreSQL server can control it. If you set trust mode that allows superusers like user postgres (or all users) to connect, they get total control of your PostgreSQL and can probably run shell commands too. You should usually only use it to change the password then restore the configuration back to the auth mode … Read more