Gregory Stark schreef:
Marc Cuypers writes:
Error:
ERROR: encoding LATIN9 does not match server's locale nl_BE.utf8
SQL state: XX000
Detail: The server's LC_CTYPE setting requires encoding UTF8.
Can i only use nl_BE and UTF-8 now?
Why can't i use LATIN9 anymore?
Is bacula
Thanks Clemens,
Schwaighofer Clemens schreef:
On Wed, Mar 11, 2009 at 19:01, Marc Cuypers wrote:
Thanks Tom,
Only...
One database was in LATIN9. When creating this database i got the same
error.
Command:
CREATE DATABASE "hardsoft" WITH OWNER = postgres TEMPLATE = template
Thanks Tom,
Tom Lane schreef:
Marc Cuypers writes:
Databases in 7.4 were encoded as utf-8. Now when importing postgresql
gives the following error:
ERROR: encoding UTF8 does not match server's locale en_US
DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
It
Hi,
I've just upgrade postgresql from 7.4 to 8.3 on a machine running debian.
And i ran in trouble. I've searched the internet but didn't find an
answer to my solution.
Is it possible to upgrade from 7.4 to 8.3 at once?
I upgraded as follows:
when 7.4 was installed i dumped the data with:
Hi Pavel,
Pavel Stehule schreef:
2008/8/1 Marc Cuypers <[EMAIL PROTECTED]>:
Hi Pavel,
Isn't the text for the Verbose Explain analyze not enough?
Is not, how can i generate it?
--
no, I am missing statistics info
try
EXPLAIN ANALYZE SELECT .
regards
I entered the comma
Hi Pavel,
Isn't the text for the Verbose Explain analyze not enough?
Is not, how can i generate it?
--
Best regards,
Marc
Pavel Stehule schreef:
Hello
please, send EXPLAIN ANALYZE output.
regards
Pavel Stehule
2008/8/1 Marc Cuypers <[EMAIL PROTECTED]>:
Hi,
I'm using
Hi,
I'm using postgres 7.4 and bacula 1.38 on debian.
In the bacula database there is a table named 'file' which has about 2.5
million rows.
In this table there is a field 'jobid' which is indexed.
The index is created with the following command:
CREATE INDEX file_jobid_idx ON file U
Tom Lane wrote:
Marc Cuypers <[EMAIL PROTECTED]> writes:
How do i make the examples in postgresql-7.3.3/src/test/examples/?
"make" works for me, assuming that I'm doing it in a built directory
tree.
[ looks at 7.3 branch... ] Hm, it looks like there's a mista
Hi,
How do i make the examples in postgresql-7.3.3/src/test/examples/?
It seems that just typing make doesn't link to the libpq library. Where
should I start make?
Just typing make gives the following output:
# make
gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-I../../../src/inter
