On Fri, Oct 16, 2015 at 04:59:12PM -0500, Jim Nasby wrote:
> BTW, I found Karsten's idea of using 'pk' for the surrogate key, and
> fk_table_name interesting. It helps avoid ambiguity from externally
> generated ID values.
That's the point :-)
Here's a real live schema using (mostly) the above a
Hi Anj:
On Thu, Oct 15, 2015 at 10:35 PM, anj patnaik wrote:
>
> I will experiment with -Fc (custom). The file is already growing very
> large.
>
I do not recall if you've already provided them, but, how large? I mean,
if you have a large database, backup will take time and ocupy space, you
ma
Hi Anj:
On Sat, Oct 17, 2015 at 3:11 AM, anj patnaik wrote:
> My question is for Francisco who replied regarding xz. I was curious what
> options he used. Thanks.
1st, we do not normally top post on this list.
Second, I do not remember the exact options I use. I can look them up,
but they are g
Thanks. what is the recommended command/options for backup and how to
restore?
I found the below online. let me know if this is better and how to restore.
Thank you
pg_dump -Fc '' | xz -3 dump.xz
On Fri, Oct 16, 2015 at 4:05 AM, Francisco Olarte
wrote:
> On Fri, Oct 16, 2015 at 8:27 AM, Guil
My question is for Francisco who replied regarding xz. I was curious what
options he used. Thanks.
On Fri, Oct 16, 2015 at 3:14 PM, Adrian Klaver
wrote:
> On 10/16/2015 12:10 PM, anj patnaik wrote:
>
>> Thanks. what is the recommended command/options for backup and how to
>> restore?
>>
>> I fou
I'm currently looking into how we might migrate an AWS-hosted database (via
RDS) from us-west-2 to us-east-1. This isn't natively supported by RDS
right now, so I was wondering if anyone has had success with 3rd-party
tools. (I'm also on 9.3, unfortunately, so I lack some of 9.4's replication
featu
> On Oct 13, 2015, at 18:27, droberts wrote:
>
> Gavin Flower-2 wrote
>>> On 14/10/15 06:36, droberts wrote:
>>> Hi, is there a problem calling ID's different when used as a FK vs table
>>> ID?
>>> For example
>>>
>>>
>>> mydimtable ()
>>> ID
>>> name
>>> description
>>>
>>>
>>> myfactta
On 18/10/15 00:13, Karsten Hilbert wrote:
On Fri, Oct 16, 2015 at 04:59:12PM -0500, Jim Nasby wrote:
BTW, I found Karsten's idea of using 'pk' for the surrogate key, and
fk_table_name interesting. It helps avoid ambiguity from externally
generated ID values.
That's the point :-)
Here's a real
