Peter Eisentraut's user avatar
Peter Eisentraut's user avatar
Peter Eisentraut's user avatar
Peter Eisentraut
  • Member for 13 years, 2 months
  • Last seen more than a month ago
242 votes

How do I find PostgreSQL's data directory?

68 votes
Accepted

What are the differences between "Stored Procedures" and "Stored Functions"?

48 votes
Accepted

Is it possible to quickly create/restore database snapshots with PostgreSQL?

45 votes

Backup only one schema and restore it on another server

44 votes
Accepted

Force PostgreSQL clients to use SSL?

40 votes
Accepted

Source several files at once with psql

37 votes

Can't rename columns in PostgreSQL views with CREATE OR REPLACE

21 votes

Is there a good way to run a trigger for each record in a postgres table?

20 votes
Accepted

Why won't some DBMS's allow rollback for certain DDL statements?

18 votes
Accepted

What other databases have a feature similar to Oracle's Flashback Query?

15 votes

How to choose a collation for international database?

14 votes
Accepted

Why are so many MPP solutions based on PostgreSQL instead of MySQL?

13 votes
Accepted

Should I invest the time to change the column type from CHAR(36) to UUID?

12 votes
Accepted

What is the difference between PostgreSQL 9.0 Replication and Slony-I?

12 votes
Accepted

Add variable value in single quoted string. Expand variable within single quotes

10 votes
Accepted

Is Oracle not suited as the database behind websites like Stackoverflow?

10 votes
Accepted

PostgreSQL: SET-ing from psql arguments

10 votes
Accepted

What is the purpose of PGBouncer's parameter server_reset_query?

9 votes

Struggling with pgBouncer

9 votes
Accepted

Postgresql 8.3: Limit resource consumption per query

9 votes
Accepted

Can PostgreSQL tell me what configuration files it's using?

9 votes
Accepted

BLOBs or references in PostgreSQL

9 votes

NULL or NOT NULL by default?

8 votes

Do higher normalized forms always meet the criteria of lower ones?

8 votes
Accepted

How to upgrade PostgreSQL minor releases without a dump/restore?

8 votes
Accepted

Why does postgres use more space for a time with timezone than a timestamp with timezone?

7 votes
Accepted

Is there better way to 'touch' a row than performing a dummy update?

7 votes
Accepted

PostgreSQL on Ubuntu - Using conf files for recovery

7 votes

What is an effective way of labeling columns in a database?

7 votes
Accepted

Can I activate PITR after the DB has been used