Re: [GENERAL] Stellar Phoenix File Recovery Software

2015-05-01 Thread Dorian Hoxha
That's spam. Can an admin ban this user/email ? On Fri, May 1, 2015 at 8:22 AM, recoverdata wrote: > When a file is deleted from your computer, its contents aren't immediately > destroyed. Windows simply marks the hard drive space as being available for > use by changing one character in the f

Re: [GENERAL] psql 8 warm standby strong start, weak finish

2015-05-01 Thread Charlton Galvarino
>"Set archive_command in the master's postgresql.conf. rysnc is a popular >choice or you can just use one of the examples from the docs. I use: > >rsync -a %p postgres@standbyhost:/path/to/wal_archive/%f >" >Simplifies the process. Oh, well, sure I could take the simpler way out. But where would

Re: [GENERAL] Stellar Phoenix File Recovery Software

2015-05-01 Thread John McKown
On Fri, May 1, 2015 at 3:51 AM, Dorian Hoxha wrote: > That's spam. Can an admin ban this user/email ? > ​However, IMO, it is a _good_ indication that this company is "less than stellar".​ "He's a _good_ bad example!" > > > > On Fri, May 1, 2015 at 8:22 AM, recoverdata > wrote: > >> When a fi

[GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?

2015-05-01 Thread Alanoly Andrews
Hello, We have a database that has been unloaded using pg_dump. This database has a table with a field defined as "lo". When restoring this database to another system, we want to avoid loading this particular table as it is very large (about 8GB of blob data) and is not needed on the target sys

[GENERAL] pg_dump permssion denied problem

2015-05-01 Thread Murphy, Kevin
Here's a variation on the theme of http://postgresql.nabble.com/Issue-dumping-schema-using-readonly-user-td5837749.html In a 9.3.4 database I don't own, I am able to create schemas, so I do, and I create various tables within a schema. However, I am unable to use pg_dump (9.3.6) to dump the st

Re: [GENERAL] pg_dump permssion denied problem

2015-05-01 Thread Murphy, Kevin
On 5/1/15, 11:10 AM, "Murphy, Kevin" mailto:murph...@email.chop.edu>> wrote: Here's a variation on the theme of http://postgresql.nabble.com/Issue-dumping-schema-using-readonly-user-td5837749.html In a 9.3.4 database I don't own, I am able to create schemas, so I do, and I create various tables

[GENERAL] A question about plans and multi-key pks

2015-05-01 Thread Steve Rogerson
We have a table: sjr_local1db=# \d cons_refs Table "public.cons_refs" Column | Type | Modifiers ---++-- code | bigint | not null ... ref_type

Re: [GENERAL] A question about plans and multi-key pks

2015-05-01 Thread Tom Lane
Steve Rogerson writes: > Why does the plan come up with 67 rows, when by definition there can be at > most one as we are searching on the pk? The rowcount estimate is made by combining selectivities of the WHERE conditions; what you're seeing is a consequence of not having very good knowledge abo

Re: [GENERAL] pg_dump permssion denied problem

2015-05-01 Thread Jerry Sievers
"Murphy, Kevin" writes: > On 5/1/15, 11:10 AM, "Murphy, Kevin" wrote: > > Heres a variation on the theme of > http://postgresql.nabble.com/Issue-dumping-schema-using-readonly-user-td5837749.html > In a 9.3.4 database I dont own, I am able to create schemas, so I do, and > I create vari

Re: [GENERAL] PostgreSQL HA config recommendations

2015-05-01 Thread Alex Gregory
This is great. Thank you both for thinking about my situation deeper. The secondary node in Ireland is purely for DR purposes only. It will be a read only copy that can be referred to only in the event that its absolutely needed. I will investigate the asynchronous methods more deeply. I cam

Re: [GENERAL] Stellar Phoenix File Recovery Software

2015-05-01 Thread Alvaro Herrera
Dorian Hoxha wrote: > That's spam. Can an admin ban this user/email ? We get a dozen of these daily, and most of them are rejected in moderation. I removed this address now. -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training &