[ADMIN] UNICODE issues with postgres

Hi there, I am using the groupware product egroupware. When importing German Holidays (containing loads of umlauts), I get this error: ERROR: Unicode characters greater than or equal to 0x1 are not supported What caracter set would you recommend (we are using german language only).

Re: [ADMIN] pg_atoi: zero-length string

Larry Rosenman wrote: Upgrade phpgroupware. This started with 7.3, and the PHPGroupware folks fixed it based on a bug report I filed. LER Hmm, my phpgroupware come right out of their CVS! Which version was this fixed in? Regards, Dani ---(end of

[ADMIN] pg_atoi: zero-length string

Hi all, I am sure this has been asked many times, but I have not found anything in the archives... I have an Application (www.phpgroupware), which submits suboptimal Queries like SELECT * FROM phpgw_accounts WHERE account_id='' Now Postgresql responds like this: *PostgreSQL Error*: 1 (ERROR:

[ADMIN] Sobig.f in the list

Guys, be careful, it seems that several Mails in the List have contained a virus - I guess its sobig.f. Cheers, Dani ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [ADMIN] ext3 block size

Wilson A. Galafassi Jr. wrote: hello. my database size is 5GB. what is the block size recommend? thanks wilson Hmm, IMHO this depends more on your IO System rather than on the DB size. It doesnt make sense to have a blocksize which your IO System (HD, Controller...) cannot fetch in one

Re: [ADMIN] Script to recreate indexes?

Bruce Momjian wrote: Have you looked in the src/contrib/reindex directory? Ahem, nope I didn´t have, until you told me so! Its exactly what I needed. Cheers, Dani ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an

Re: [ADMIN] Backup routine

Hi Enio, Enio Schutt Junior wrote: Hi Here, where I work, the backups of the postgresql databases are being done the following way: There is a daily copy of nearly all the hd (excluding /tmp, /proc, /dev and so on) in which databases are and besides this there is also one script which makes

Re: [ADMIN] Partition DB Tables by month

Mendola Gaetano wrote: you can easilly accomplish this using a partial index. Would that really work with a view? Can you post a syntax example for this? Regards, Dani ---(end of broadcast)--- TIP 2: you can get off all lists at once with the

Re: [ADMIN] Replication/Failover/HA solution

Ragnar Kjørstad wrote: On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote: I am having a hard time selecting a Replication/Failover/HA solution for PGSQL. What is troubling is the number of solutions available in various states of development. Does the fact that dbmirror and

[ADMIN] Script to recreate indexes?

Hi guys, I wnated to write a nice littel script to regenerate Indexes, but I am struggling with the Array type... (Can anydody tell me why the PostgreSQL Catalog does use this non-relational stuff??) Does anyone have a script either showing the Array stuff or (even better :-) the creation of Index

Re: [ADMIN] Partition DB Tables by month

Romildo Wildgrube wrote: Hi, Is there a way to break the data files by month like in Oracle so that I can easely drop the tables on a monthly basis? Is this something postgres supports or is there a work around solution? Hmm, as far as I know its not supported. But I could think of a solution

Re: [ADMIN] Partition DB Tables by month

Ray Ontko wrote: One limitation to the UNION approach is that you can't insert, update, or delete through the UNION view. At some point the application needs to understand how the virtual table is partitioned into these month-specific tables. Romido: Why not simply delete the rows each month

[ADMIN] Whats wrong with www.postgresql.org

Hi guys, when I navigate to www.postgresql.org, all I see is the default Apache screen : If you can see this, it means that the installation of the Apache web server http://www.apache.org/foundation/preFAQ.html software on this system was successful. You may now add content to this directory and

Re: [ADMIN] PG_dump fatal error (second post)

Nick Fankhauser wrote: ... pg_dump: [tar archiver] could not write to tar member (wrote 39, attempted 166) ... Hi Nick, how big does your tar file get when you get the error? I would guess that its 2GB at this time, which would indicate that you just hit a File System Limit. To prevent this,

Re: [ADMIN] pg_dump: dumpBlobs(): error reading large object: ERROR:

Tom Lane wrote: Sergio Pili [EMAIL PROTECTED] writes: pg_dump abort with this error: pg_dump: dumpBlobs(): error reading large object: ERROR: cannot read block 6389 of pg_largeobject_loid_pn_index: Input/output error This error is caused by bad block on my hard drive? Looks like

Re: OT [ADMIN] Database migration

Dilan Arumainathan wrote: I am trying to migrate a database from Oracle to Postgresql. I am using the PgAdmin database migration wizard (1.5.60-Dev) to do this. Using ODBC I am able to migrate small tables but I have a few tables that have over 10 million rows that are failing. I know the reason

[ADMIN] Documentation of Concepts

Hi everybody, maybe you have followed the tread before about migratiing from Oracle to Postgres. In there I quoted a Document from Oracle called Oracle Concepts. In there, Oracle explains exactly, what goes on under the hood of Oracle. (Like How they handle concurrency, locking...) Is there such a

Re: [ADMIN] Pls. help me to clarify my doubts.

Gaetano Mendola wrote: [EMAIL PROTECTED] wrote: hi, Sir, i follow your procedure of Postgres installation (version 7.1.3) on linux 2.4.7-10. I want to know how to enable syslog and mention the log information will store in /var/postgreslog directory path.. not sure abt 7.1.3 , but in

Re: [ADMIN] PostgreSQL calibration

Chris Gamache wrote: What's your thought on creating some type of calibration applet that will divine proper settings for the PostgreSQL performance related variables by taking into consideration the speed of the machine, amount of RAM, access time of the filesystem, and the speed of various