I have a database that's about 600 GB. I did a pg_dump (pg_dump --format plain
--create --encoding UTF8 --oids --verbose --file "/var/tmp/145_backup.sql"
"digi") and, after 442 GB, I got an error, "pg_dump: Error message from server:
ERROR: missing chunk number 0 for toast value 49209130 in pg
y. Sure enough, there is no
such file - only 5905.
From: Tom Lane [t...@sss.pgh.pa.us]
Sent: Monday, March 11, 2013 12:10 PM
To: Steve Erickson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Upgrading postgresql-8.4
Steve Erickson writes:
>
An option would be to create a column of type tsvector. That way you could do
text searches using partial words or words and get results including those
containing forms of the word.
From: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org]
o
rial NOT NULL,
email_path text,
state character(1) DEFAULT 'N'::bpchar, -- N = New Email, P=Processing,
D=Deleting
fetch_date timestamp without time zone DEFAULT now(),
ingest_date timestamp without time zone
)
Steve Erickson
Senior Developer
266 East 7th Street, Floo
I'm running PostgreSQL 8.3 with pl/python 8.3. I am getting a different
date/time format when executing the below examples. The results are the
same whether I use os.popen or os.system. In plpython, I run:
import os
cmd = 'ls -al /var/log/messages > /var/tmp/log'
x = os.popen(cmd)
for al
