On Mon, Oct 10, 2011 at 9:26 AM, Albe Laurenz wrote:
> I wrote:
> [fanlijing wants to write bytea to file]
>> A simple
>> COPY (SELECT byteacol WROM mytab WHERE ...) TO 'filename' (FORMAT
> binary)
>> should do the trick.
>
> Corrections:
> a) "binary" must be surrounded by single quotes.
> b)
On Tue, Aug 16, 2011 at 11:27 AM, Evan Rempel wrote:
> Technically it can be done, but just because we can do something does not
> mean we should do something. Having said that...
>
> We have been using a middleware product that shall remain nameless,
> that goes against a large commercial databas
On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain
wrote:
> 2011/5/3 Merlin Moncure :
>>
>> no it will not, or at least there is no guarantee it will be. the
>> only way to reset the buffers in that sense is to restart the database
>> (and even then they might not be r
On Tue, May 3, 2011 at 8:30 AM, raghu ram wrote:
> On Tue, May 3, 2011 at 6:01 PM, Raghavendra
> wrote:
>>
>> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote:
>>>
>>> On Tue, May 3, 2011 at 11:54 AM, raghu ram
>>> wrote:
>>>
>>> > It may be a silly question, still out of curiosity I want to k
On Thu, Mar 3, 2011 at 2:16 AM, Heikki Linnakangas
wrote:
> On 03.03.2011 09:12, daveg wrote:
>>
>> Question: what would be the consequence of simply patching out the setting
>> of this flag? Assuming that the incorrect PD_ALL_VISIBLE flag is the only
>> problem (big assumption perhaps) then simpl
On 1/21/09, paulo matadr wrote:
>
> I everyone, need help!!!
> My aplication return erro:
>
> 2009-01-20 10:22:03,264 INFO [STDOUT] Caused by: org.postgresql.util.
> PSQLException: ERROR: invalid memory alloc request size 1705447581
What exactly were you doing when you got the error?
How big is
On Wed, Nov 19, 2008 at 10:54 AM, Kranti™ K K Parisa
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have defined sequence on a table something like this
>
>
> CREATE SEQUENCE items_unqid_seq
> INCREMENT 1
> MINVALUE 0
> MAXVALUE 9223372036854775807
> START 7659
> CACHE 1;
>
> this is on a table c
On Wed, Aug 27, 2008 at 9:52 AM, Michael Nolan <[EMAIL PROTECTED]> wrote:
>> This is a nice touch. With a little bash-fu you could do a find |
>> xargs rm and list/kill the files in one pass. In the standby setups
>> I've done I usually script the whole process, a prep on the main and a
>> startu
On Wed, Aug 27, 2008 at 9:18 AM, Michael Nolan <[EMAIL PROTECTED]> wrote:
> I have what I have sometimes called a 'tepid spare' backup. Once a week I
> copy the physical files over to another system (actually to two of them) and
> every few hours I make sure the archived WAL log files are in sync
On Tue, Aug 26, 2008 at 9:04 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> On Tue, Aug 26, 2008 at 5:38 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
>
>
>> If you ever want to mess around with log
>> shipping I strongly suggest you go through the motions of se
On Tue, Aug 26, 2008 at 6:53 PM, Richard Broersma
<[EMAIL PROTECTED]> wrote:
> From the following link:
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP
>
> Step 3 says to perform the back up.
>
>Does this mean a File System Backup of the Data direct
On 3/26/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Sorin N. Ciolofan" <[EMAIL PROTECTED]> writes:
>I have to manage an application written in java which call another module
> written in java which uses Postgre DBMS in a Linux environment. I'm new to
> Postgres. The problem is that for large amo
postgresql is a dataware housing tool :) what exactly are you looking for?
merlin
On 7/19/06, vamsee movva <[EMAIL PROTECTED]> wrote:
Hello all
could you please tell me if there are any dataware housing tools for
postgresql
Thanks in advance
vamsee
---(end of broadc
On Mon, 2002-11-25 at 23:03, David Gilbert wrote:
>
> I'm on a bit of a mission to stamp out this misconception. In my
> testing, all but the most expensive hardware raid controllers are
> actually slower than FreeBSD's software RAID. I've done my tests with
> a variety of controllers with the sa
14 matches
Mail list logo
