run this coversion command
time iconv -c -f UTF8 -t UTF8 -o newdump.sql olddump.sql
Josh O'Brien
Mario Splivalo wrote:
Hello.
I have a database created with -E UTF-8. I need to transfer it to
pg8.1.2.
First I dumped the database:
pg_dump -v -E UTF-8 the_database > the_database.psql
Then I
> My database it was going fine until today.
>
> The error message is:
>
> "Could not start the PostgreSQL Database Server [version #
> inserted here] service on local computer.
> The service did not return an error. This could be an
> internal Windows error or an internal service error.
> I
Mario Splivalo <[EMAIL PROTECTED]> writes:
> psql:the_database.psql:86: ERROR: invalid UTF-8 byte sequence detected
> near byte 0x8d
> CONTEXT: COPY _netsms, line 1367, column text: "Padamo u pozu 69.uz
> \umas mog macana u usta.a ja tvoju ljepu picu"
7.4's checking for valid UTF8 code seque
This is the second time in the past few days that lechlecha.jct.ac.il
has injected a bunch of old messages into pgsql-admin. Can you arrange
to blacklist that machine so it doesn't happen again?
One example attached, but there were about two dozen this morning.
regards, t
"Erik G. Burrows" <[EMAIL PROTECTED]> writes:
> So, my question is: What does the duration time in the serverlog
> reflect? Is it just the time the server took to execute the statement,
> or does it reflect also query receive and response transmit time?
The former. The server has no way to measur
Zitat von Scott Marlowe <[EMAIL PROTECTED]>:
But you're not running the least buggy version of the 7.4 branch. The
7.4 branch is up to 7.4.9. If you are runing 7.4.2 then you haven't
installed all the updates supplied by Suse for their distribution (or
Suse backports bug fixes from 7.4.9 to 7.4
On Sat, Feb 11, 2006 at 10:48:08AM +0530, Nalin Bakshi wrote:
> Hi!
> My project requires me to fetch some data from a a table and write it
> into a flat file. How can I do this. Could you help?
> regards,
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
See also \copy on
http://w
[EMAIL PROTECTED] writes:
> Zitat von Scott Marlowe <[EMAIL PROTECTED]>:
>> But you're not running the least buggy version of the 7.4 branch. The
>> 7.4 branch is up to 7.4.9. If you are runing 7.4.2 then you haven't
>> installed all the updates supplied by Suse for their distribution (or
>> Suse
[EMAIL PROTECTED] (Aldor) writes:
> I'm just curious about a VACUUM plan of this table:
>
> 1st) When to do VAUUM?
> 2nd) How often to do VACUUM?
> 3rd) With which postgresql.conf paremeters to set up vacuum?
> 4th) When to do a VACUUM FULL?
> 5th) Can autovacuum of 8.1 be used in this case?
>
> I'