Reputation
5,057
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
12 27
Newest
 Yearling
Impact
~187k people reached

  • 0 posts edited
  • 0 helpful flags
  • 141 votes cast
Jul
30
comment Index Generation in Postgres
This doesn't apply to his case, because he is using pg_dump, which already creates the indexes after loading the data. It says so in the question.
Jul
2
comment Postgresql row-level encryption
Not that it would make a difference in this case, but you are linking to the PostgreSQL 8.0 documentation, which is more than 6 years old.
Jun
27
comment PostgreSQL: Disk space not released after TRUNCATE
It's conceivable that another backend process still has a file descriptor to the file open. If this happens again, I'd try terminating all other backend processes, just to see whether it makes a difference.
Jun
22
answered Is it possible to quickly create/restore database snapshots with PostgreSQL?
Jun
20
answered PostgreSQL on Ubuntu - Using conf files for recovery
Jun
16
answered Source several files at once with psql
Apr
28
answered How to hide metadata from Postgres users?
Apr
27
answered Postgres 8.4 — connection refused (remote)
Apr
26
answered What are the differences between “Stored Procedures” and “Stored Functions”?
Apr
19
awarded  Enlightened
Apr
19
awarded  Nice Answer
Apr
17
comment Where does the magic column “name” come from?
It would help to show the definition of site.
Mar
2
comment How to upgrade PostgreSQL minor releases without a dump/restore?
I didn't downvote anything.
Mar
2
answered How to upgrade PostgreSQL minor releases without a dump/restore?
Mar
1
comment How to upgrade PostgreSQL minor releases without a dump/restore?
Which part of "stop the database server, install the updated binaries, and restart the server" are you having problems with?
Feb
25
answered Get a list of databases that have a certain table
Feb
21
answered PostgreSQL: SET-ing from psql arguments
Feb
20
answered Postgresql 8.3: Limit resource consumption per query
Feb
20
answered How do I find PostgreSQL's data directory?
Feb
20
comment How do I find PostgreSQL's data directory?
This is specific to Debian/Ubuntu.