Top "Postgresql-8.4" questions

This is for PostgreSQL questions specific to version 8.4.

What is the default username and password for PostgreSQL?

I am working on an open source application that has PostgreSQL as its default DBMS. Now when I install it …

postgresql postgresql-8.4
How to log data change in postgresql?

This question may seem to be a possible duplicate of some other questions that are related to this topic. I've …

postgresql postgresql-8.4 audit-trail
ERROR: must be superuser to alter superusers

Unfortunately, I have removed super user privileges from postgres user in PostgreSQL. And currently I have not any super user …

postgresql-8.4
PostgreSQL: Add Interval to Timestamp from column value

I need to add minutes coming from an integer column with a timestamp to compare to another column. Here's an …

postgresql postgresql-8.4
How to add primary key to View?

I have a view and want to make one attribute a primary key. CREATE VIEW filedata_view AS SELECT num …

postgresql postgresql-8.4
How to create an "on-the-fly" mapping table within a SELECT statement in Postgresql

I'm creating a select statement that combines two tables, zone and output, based on a referenced device table and on …

sql postgresql postgresql-8.4
Postgres SSL error

I'm trying to run a Drupal migration via SSH and drush (a command line shell), copying data from a postgres …

postgresql drupal postgresql-8.4
Database table size did not decrease proportionately

I am working with a PostgreSQL 8.4.13 database. Recently I had around around 86.5 million records in a table. I deleted almost …

postgresql postgresql-8.4 vacuum
PG 8.3, Disk Full, server fails to start

This question concerns Postgresql 8.3. I cannot yet create tags so Ichose version 8.4 as tag. It's a test server, but I …

postgresql postgresql-8.4
SQL - How to check if item is in a list in a record

I have have a column name MyRoles that contains a list of items (integers) stored in a field named UserRoles. …

sql postgresql-8.4 denormalized