161 reputation
8
bio website
location
age
visits member for 11 months
seen Apr 24 at 15:11
stats profile views 5

Sep
10
comment Postgresql WAL Archiving, How to do it properly?
ok, now i'm taking a standard logical dump to restore from just in case
Sep
10
comment Postgresql WAL Archiving, How to do it properly?
i'm working on that now, setting up separate instance of the VM running the Postgres server, and going to drop all tables then restore via barman. not sure how to check vs what should be there though?
Sep
10
answered Postgresql WAL Archiving, How to do it properly?
Sep
10
asked Postgresql WAL Archiving, How to do it properly?
Jul
2
awarded  Supporter
Jun
29
comment Possible to keep max number of records in postgresql?
@dexso should be perfect, thank you
Jun
29
accepted Possible to keep max number of records in postgresql?
Jun
29
comment Possible to keep max number of records in postgresql?
also i was hoping that postgres could tell which one was older itself, but if not as we don't have ID's it could use our date created timestamp field "2012-06-22 17:17:52.692514"
Jun
29
comment Possible to keep max number of records in postgresql?
we can execute it periodically, and we're sure we won't need them once the table gets big enough to require this, I'm just trying to automate DB maintenance as much as possible :)
Jun
29
asked Possible to keep max number of records in postgresql?
Jun
26
awarded  Student
Jun
26
comment Is database normalization dead?
I think the main problem behind this is that the people writing the ORMs are not database experts, they're programmers who are trying to get a job done and they don't always want to have to deal with database best practises as they have a lot of other important stuff to do. they just want some automatic tool to hold all their data do they can get on with their job.
Jun
26
awarded  Scholar
Jun
26
accepted Search for null in id column over all tables programmatically
Jun
22
comment Search for null in id column over all tables programmatically
nothing as of yet, i'm not that good with postgresql
Jun
22
asked Search for null in id column over all tables programmatically