> >> In other words, by WRONGLY attaching confidentiality notices, courts
> >> might decide to ignore them even in cases where you imagined they
> >> ought to be legitimate...
>
> > I've thought about that before and agree completely. Unfortunately this
> > disclaimer is added by our perimeter UTM
"Phillip Smith" <[EMAIL PROTECTED]> writes:
>> In other words, by WRONGLY attaching confidentiality notices, courts
>> might decide to ignore them even in cases where you imagined they
>> ought to be legitimate...
> I've thought about that before and agree completely. Unfortunately this
> disclaim
> You should think before you attach these sorts of "confidentiality"
> notices.
>
> If you put them on messages like this that are *OBVIOUSLY* being sent
> to publicly-available mailing lists, this may undermine future claims
> of material being supposedly-confidential.
>
> In other words, by WR
[EMAIL PROTECTED] ("Phillip Smith") writes:
>> If doesn't have another way, how can I put the
>> "header" in the begin of file without open?
>> With "cat >>" command I put in the end.
>
> After the split files are loaded on the new server file system:
> cat splitfile*.txt > bigfile.txt
>
Try splitting by line count instead of size:
-l, --lines=NUMBER
put NUMBER lines per output file
pg_dump | split -l 32000
You'll have to experiment to find how many lines will give you a roughly
appropriate size for your purposes.
Alternatively, another option is to get an USB external HDD
Sorry to insist in this question, but now I was doing
some test and I notice that is a good idea to use
split utility.
This is because the output file got X bytes specified,
cut the rest of the line and will not import after.
In my example, I generated more than 2 files equal to
1MB. But already
Hi,
On Dienstag, 18. Dezember 2007, Alvaro Herrera wrote:
| A.Burbello wrote:
| > If doesn't have another way, how can I put the
| > "header" in the begin of file without open?
| > With "cat >>" command I put in the end.
|
| Don't -- you can put the header in a separate file and do something like
A.Burbello wrote:
> If doesn't have another way, how can I put the
> "header" in the begin of file without open?
> With "cat >>" command I put in the end.
Don't -- you can put the header in a separate file and do something like
(cat header-file ; cat split-1 ; cat tail-file ) | psql
lather, rin
> If doesn't have another way, how can I put the
> "header" in the begin of file without open?
> With "cat >>" command I put in the end.
After the split files are loaded on the new server file system:
cat splitfile*.txt > bigfile.txt
psql < bigfile.txt
THINK BEFORE YOU PRINT - Sa
Thank you for your response!
I tested the split command and I got another problem
because for each file doesn't have the "COPY" header.
As well I said early, one table has more than 30G and
I need to import to another server (linux), but by dvd
media because doens't have network connection.
What
Scott Marlowe wrote:
On Dec 17, 2007 2:06 PM, A.Burbello <[EMAIL PROTECTED]> wrote:
I consider this way a good practice to transport the
files. This is because I have table that has more than
30GB.
But if the OS was windows, couldn't split the files
because postgres doesn't has this feature!
Cou
On Dec 17, 2007 2:06 PM, A.Burbello <[EMAIL PROTECTED]> wrote:
> I consider this way a good practice to transport the
> files. This is because I have table that has more than
> 30GB.
> But if the OS was windows, couldn't split the files
> because postgres doesn't has this feature!
> Could be a good
I consider this way a good practice to transport the
files. This is because I have table that has more than
30GB.
But if the OS was windows, couldn't split the files
because postgres doesn't has this feature!
Could be a good option if postgres had native.
Weel, I will try this:
eg: $ pg_dump postg
On Dec 15, 2007 11:42 AM, A.Burbello <[EMAIL PROTECTED]> wrote:
> Hi people,
>
> How can I export (dump) database more than 1 file?
> I have great table and can't split.
> Like Oracle, just set the parameter filesize and the
> files name, and dump in several files.
You could pipe the output of pg_
Hi people,
How can I export (dump) database more than 1 file?
I have great table and can't split.
Like Oracle, just set the parameter filesize and the
files name, and dump in several files.
Could I do it the same way in PG?
Thank you in advance.
Abra sua conta no Yahoo! Mail, o único sem
15 matches
Mail list logo
