Re: [ADMIN] invalid multibyte character for locale

Tom Lane wrote: Well, in that case your encoding is indeed at variance with your locale setting ;-). Perhaps you should declare the encoding as SQL_ASCII. The immediate problem is that mbstowcs() is being called and it evidently doesn't know what to do in C locale. SQL_ASCII (or any single-byte

[ADMIN] CVS Database

Hi,   I am using Postgres database for my Application.   All my developers will be updating the database during development, i.e like Adding a New Field, Drop Field, Add Records etc things.   The main database will be on Server, My question is ,   Question 1: If i want to update the database which

Re: [ADMIN] pg_passwd file missing

Lorenza Ferrario wrote: > Hi, > > I've just sturted using postgresql 8 and I faced the following > problem: I want to use the "password" method for the user > authentication. In previous release, I linked the password_file to the > dbms through the pg_passwd command, placed in the POSGTRES_HOME/bi

[ADMIN] Statistics Collector & Query Optimizer, any relation?

Hi, list, Does statistics has any relation to query optimizer? If I turn on statistics collector, will it do help to query optimizer? Regards Simon Chen. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] invalid multibyte character for locale

Bjoern Metzdorf <[EMAIL PROTECTED]> writes: > CREATE INDEX foobar_uvalue_key ON foobar USING btree > (upper((value)::text)); > ERROR: invalid multibyte character for locale > HINT: The server's LC_CTYPE locale is probably incompatible with the > database encoding. > I forgot to say that I am u

Re: [ADMIN] PostgreSQL 8.0.1 problem

I run vacuum analyze and the view WORKS!! A lot of thanks Scott, (one thousand or more ;) Indibil Scott Marlowe wrote: > On Tue, 2005-02-22 at 14:03, Indibil wrote: >> Hi: >> >> I want migrate to PostgreSQL 8.0.1 for Windows from PostgreSQL 7.4.1, but >> I have a big problem. >> >> In 7.4.1

Re: [ADMIN] invalid multibyte character for locale

I forgot to say that I am using UNICODE for database encoding (initdb -E UNICODE and createdb -E UNICODE). Bjoern Metzdorf wrote: Hi, I am testdriving postgresql 8.0.1. On importing my old dump which works fine on 7.4.6 I am getting errors like this one: CREATE INDEX foobar_uvalue_key ON foobar

[ADMIN] invalid multibyte character for locale

Hi, I am testdriving postgresql 8.0.1. On importing my old dump which works fine on 7.4.6 I am getting errors like this one: CREATE INDEX foobar_uvalue_key ON foobar USING btree (upper((value)::text)); ERROR: invalid multibyte character for locale HINT: The server's LC_CTYPE locale is probably

Re: [ADMIN] Partitioning Option?

"Tomeh, Husam" <[EMAIL PROTECTED]> writes: > (I was referring to object partitioning. For instance, if I have a huge > table with US counties as my partition key, I could create partitions > within the same table based on the partition key (a US county for > example). When querying, the engine will

Re: [ADMIN] Lingering Checkpoint Process

Thanks for the response Tom. The checkpoint process seems to be just sitting. I'll post the details of strace/gdb in the morning. Thanks again! --Cory BIS Database Engineering -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 1:13 PM To:

Re: [ADMIN] Partitioning Option?

Thanks Josh, I'll check out the namespace concept. (I was referring to object partitioning. For instance, if I have a huge table with US counties as my partition key, I could create partitions within the same table based on the partition key (a US county for example). When querying, the engine wil

Re: [ADMIN] Partitioning Option?

Tomeh, Husam wrote: Does PostgreSQL support/allow "partitioning" of objects like tables and indexes, like Oracle does? We support tablespaces but not table partitioning. You can get around this by using namespaces and unions however. Sincerely, Joshua D. Drake I have searched the docs, but hav

Re: [ADMIN] Lingering Checkpoint Process

"Cory Vokey" <[EMAIL PROTECTED]> writes: > Hi all, I'm seeing a checkpoint process lingering around for ~ 24hrs on > one of my test systems and WAL logs are accumulating. It's running > postgres 7.4.6. Is the checkpoint process actually doing anything, or just sitting? (strace'ing it would reveal

[ADMIN] Partitioning Option?

Does PostgreSQL support/allow "partitioning" of objects like tables and indexes, like Oracle does? I have searched the docs, but haven't found anything to partitioning. Thanks, -- Husam ** This message contains confidential i

Re: [ADMIN] Question

First its bad style to use a generic subject like "Question". Use something related to the specific problem. "Help" is an other poor choice. Second you need to put in a lot more information about your setup. As an absolute minimum provide postgresql release and operating system. Third it sounds l

[ADMIN] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[ADMIN] Question

Hi, I have a database with 100 GB size, I never have done a vacuumdb to it, analizyng, there is a table witn almost 25 GB, I have to run a Vaccum to clean it.. This is a longer operation. But somebody said me that if I make a backup(pg_dump), drop the database, create db, an then restore ag

[ADMIN] Lingering Checkpoint Process

Hi all, I’m seeing a checkpoint process lingering around for ~ 24hrs on one of my test systems and WAL logs are accumulating.  It’s running postgres 7.4.6.   Research up to date indicates faulty memory or disks.    Has anyone else seen this behavior?  Previously, I had to re-init the D

[ADMIN] logging time with queries

Hi,   I need some help on a logging situation. I am logging the stdout to a file (/var/log/pglogs) like this:   In Postgresql.conf: ** syslog = 0  # range 0-2; 0=stdout; 1=both; 2=syslog syslog_facility = 'LOCAL0' syslog_ident = 'postgres'  

[ADMIN] unsubscribe

unsubscribe [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

[ADMIN] where is the logfile for postmaster located

Consider that i had started the postmaster using the below command. /usr/local/pgsql/bin/pg_ctl -D data -l data_log start But i need to know at any instance which logfile (name and location) the postmaster is writing to.?. (considering i have forgotten the name and location of the logfile). Hope

Re: [ADMIN] Encoding types

> Dear, > > I have the following problem : > > On an win32 box (win2003 server) we selected as encoding > SQL_ASII, we store data into the tables with accents ... If > we look at it with pgadminIII it looks nice. From the > cmd-prompt and via ODBC on the same box, the accents are > strange ch

Re: [ADMIN] PostgreSQL 8.0.1 problem

> Hi: > > I want migrate to PostgreSQL 8.0.1 for Windows from > PostgreSQL 7.4.1, but I have a big problem. > > In 7.4.1 I have a large view with nested views. It lasts 1 > minute and 20 seconds to finish. In 8.0.1 for Windows it > lasts I don't know. One hour, two hour, one day... I > al

Re: [ADMIN] 64 bit rpms for 7.4.7??

Hi, > I still cant see RedHat 9 Source RPMS for the Postgres 8.0.1 in FTP > mirror sites , any ideas when it will up on FTP mirror site ? I don't have a x86_64 RedHat 9 machine, so I can't help you with that... Sander. ---(end of broadcast)--- TI