Reputation
1,256
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 18
Newest
 Enthusiast
Impact
~130k people reached

  • 0 posts edited
  • 0 helpful flags
  • 75 votes cast
Dec
1
awarded  Enthusiast
Nov
30
awarded  Nice Answer
Nov
17
awarded  Enlightened
Nov
17
awarded  Nice Answer
Nov
6
revised Determine when a PostgreSQL database was last changed
added 112 characters in body
Nov
2
answered Copy indexes from one table to another
Oct
16
comment PostgreSQL error moving data directory to home folder
My guess is that the problem is permissions related. If /home/USER is chmod 700 (which it should be) and USER != postgres then it won't work. Does the data directory need to be under /home/USER ?
Aug
27
awarded  Yearling
May
27
awarded  Notable Question
May
13
revised Postgres: difference between CTE and temporary table
fixed typo
May
13
comment Storing table history - is this a good use case for Postgres's table partitioning / inheritance?
Have you considered using the temporal_tables extension? github.com/arkhipov/temporal_tables
Apr
15
reviewed No Action Needed Insert date values in a created table
Apr
15
awarded  Custodian
Apr
15
reviewed No Action Needed How to segment account info and profile info?
Mar
20
answered Postgres: difference between CTE and temporary table
Sep
11
awarded  Critic
Aug
27
awarded  Yearling
Aug
11
comment PosgreSQL: very slow select on a single table with no joins
What does select pg_relation_size('data'); look like?
Jul
29
comment Checking whether two tables have identical content in PostgreSQL
@Faheem Mitha -- that is correct
Jul
29
answered Checking whether two tables have identical content in PostgreSQL