On 31 May 2010 18:59, Tom Lane wrote:
> Seems like you must have a kernel/filesystem issue, but I don't know
> what either. CREATE DATABASE just copies the contents of template1
> using some absolutely straightforward code (look into src/port/copydir.c)
> so it's entirely filesystem-limited.
Tha
psql coon I'm trying to restore a database
that has 60 GB in size, where there is a table with 38 million records,
has raised 18 million records when the restore process fails on a
syntax error, the backup was made with a file. sql as the best way I can do
to restore??
Alexander Angel
Tena Sakai wrote:
I got it to work by emulating what you wrote.
But I think you meant -A, not -At below.
psql -c "select name,setting from pg_settings limit 1" -d postgres -At
-F $'\t'
You had -t in your original to turn off the display of column names and
the counts at the end, and
2010/6/2 ALEXANDER JOSE
> psql coon I'm trying to restore a database that has 60 GB in size, where
> there is a table with 38 million records, has raised 18 million records when
> the restore process fails on a syntax error, the backup was made with a
> file. sql as the best way I can do to res
Hi Greg,
My apologies. I hadn't realized that -At was a combination
of -A and -t. Rather, I kept thinking that t as argument
to -A.
Regards,
Tena Sakai
tsa...@gallo.ucsf.edu
On 6/1/10 11:02 PM, "Greg Smith" wrote:
> Tena Sakai wrote:
>> I got it to work by emulating what you wrote.
>> But
