meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 11 months |
| seen | Apr 24 at 15:11 | |
| stats | profile views | 5 |
|
Jan 31 |
comment |
Master to Slave to Slave Configuration in MySQL let us continue this discussion in chat |
|
Jan 31 |
comment |
Master to Slave to Slave Configuration in MySQL I have recently updated the snapshot on server 2 by request of the boss |
|
Jan 31 |
comment |
Master to Slave to Slave Configuration in MySQL doesn't appear to have it running |
|
Jan 31 |
comment |
Master to Slave to Slave Configuration in MySQL 50MB, server 1 can't go down for more than a minute, server 2/3 are expendable for now, No. |
|
Sep 24 |
comment |
Maximum number of databases for single instance of PostgreSQL 9 Wal Archiving for a backup would make sense here. |
|
Sep 11 |
comment |
Postgresql WAL Archiving, How to do it properly? Ok, restore works, but there were a few things they didn't mention in the Docs. namely, that the directory you need to set the restore command to is the data area for postgresql (on ubuntu this is /var/lib/postgresql/<main_version>.<minor_version>/main/), also it doesn't seem to do everything for you in regards to getting the server back online, you still have to physically start the server again, but i suppose thats for safety |
|
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? |
|
Jun 29 |
comment |
Possible to keep max number of records in postgresql? @dexso should be perfect, thank you |
|
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 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 22 |
comment |
Search for null in id column over all tables programmatically nothing as of yet, i'm not that good with postgresql |
