[GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Benjamin Adams
I have a server that has a column timestamp without timezone. Is the time still saved? if I select column with timestamp it will show server timestamp with timezone. But If I move the data from EST to Central will the timestamp with timezone be correct? Or will it just not make the adjustment? T

[GENERAL] External Storage of data dir

2012-08-10 Thread Benjamin Adams
I'm looking to expand my old home server running on Ubuntu Server I only have ~100 GB system drive (4 HDs, Raid 5, SAS). Backups are to a USB 1.1 (2TB) I do have lots of spare old SATA HD's with a spare 1GB connection to server box. I have been looking into getting an iSCSI system to run my /data

[GENERAL] Get DB Size by row

2012-07-20 Thread Benjamin Adams
Hello, I'm looking to do something like: select month, mb_size(description) from data where year = 2012 group by month I also am looking for raw size not compressed size. Thanks Ben -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: ht