[GENERAL] Migrate whole cluster to utf8

Hi all I have a db cluster (around 50GB of data ) in LATIN2  encoding. Now I need to dump whole cluster because of upgrade to newer  version of pstgresql. But I need to  have new cluster created with utf8 encoding  And databases in that clusters tooo (with cs_CZ locale) what is the best /safe p

[GENERAL] Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"

Hi, all. I need help. pg_exec(): Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250" It is a strange. First there was a database with latin2 encoding. to this database connect an aplicaton with "set client encoding to win1250"

Re: [GENERAL] full_page_writes on SSD?

Hi, I investigate bit about SSD  and how it works and need to be aligned . And I  conclude that in the ideal world we need a  general --ebs=xxx switch in various linux tools to ensure alignment. Or make calculation by had.. On the market there are SSD disks with page size 4 or 8 kb. But ther

[GENERAL] Re: [GENERAL] Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"

Hi, Thanx for explanation. but how to solve this  in existing  database ? -- Původní zpráva -- Od: Albe Laurenz Komu: 'NTPT *EXTERN*' , pgsql-general@postgresql.org Datum: 25. 11. 2015 12:54:17 Předmět: Re: [GENERAL] Query failed: ERROR: character with byte se

[GENERAL] RE: [GENERAL] Query failed: ERROR: character with byte sequence 0xc2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250"

errors..  I suspect -- Původní zpráva -- Od: Albe Laurenz Komu: 'NTPT *EXTERN*' Datum: 25. 11. 2015 14:47:46 Předmět: RE: [GENERAL] Query failed: ERROR: character with byte sequence 0xc 2 0x96 in encoding "UTF8" has no equivalent in encoding "WIN1250&qu

[GENERAL] Old source code needed

Hi all, I need to find a old source codes for Postgresql9.0 BETA relases.  could You help me ?

Re: [GENERAL] Old source code needed

zpráva -- Od: Adrian Klaver Komu: NTPT , pgsql-general@postgresql.org Datum: 26. 11. 2015 22:49:13 Předmět: Re: [GENERAL] Old source code needed "On 11/26/2015 01:29 PM, NTPT wrote: > Hi all, I need to find a old source codes for Postgresql9.0 BETA relases. > could You help m

[GENERAL] Rapid Seek Devices (feature request)

Hi all I have some idea/feature request. Now, there are several devices available, that can be called "rapid seek devices" (RSD in future text). I mean SSD disks, some devices like gigabyte I-RAM and other (semi)profesional "ram disk like" solutions for example Acard ANS-9010 . Rapid seek bec

Re: [GENERAL] Rapid Seek Devices (feature request)

speed for sequentional and random operation of the storage device(s) (tablespaces) involved. Jeremy Harris napsal(a): On 08/17/2009 03:24 AM, Craig Ringer wrote: On 16/08/2009 9:06 PM, NTPT wrote: So I suggest we should have "random_page_cost" and "Sequential_page_cost"

[GENERAL] Open source database design tool , alternative to MicroOLDAP

Hi all. is there available some freeware and/or opensource visual database design tool for postgresql ? Something like commercial microOLAP ? thanx for help -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mail

[GENERAL] Named / preparsed / preplaned(prepared) queries - Feature proposal

Hi all I have an idea how to extend postgresql feature set. I sugest named / preparsed / preplamned query mechanizm where named query is a simpliest form and preplaned query is the most sofisticated (implementation wise). Ie to have ability to assign a global and may be persistant NAME (or

[GENERAL] Re: Re: [GENERAL] Named / preparsed / preplaned(prepared) queries - Feature proposal

something similar... # Původní zpráva # Od: John R Pierce # Předmět: Re: [GENERAL] Named / preparsed / preplaned(prepared) queries - Feature # proposal # Datum: 06.11.2011 17:35:57 # # On 11/06/11 6:07 AM, NTPT wrote: # > I

Re: [GENERAL] In memory Database for postgres

If you need to run some database really fast, try to put only all your indexes onto ram disk. Look here... http://www.linux.com/feature/142658 They use SSD to store indexes (not data) for postgresql. A think the same conclusions should apply for ram disk too. And in wrost case (power off for

Re: [GENERAL] row numbering

If you insert the results of your query into a table with a serial column, the serial column will do what you want.. Plus add a huge overload... ? Having some sort of line numbering in result query would be nice... - Original Message - From: "Mike Harding" <[EMAIL PROTECTED]> To: "P

Re: [GENERAL] More concurent transaction over single connection

(AFIAK ), I am affraid, that multiple transactions over the single connection in this scenario will result a complette mess. I am right ? Please execuse my wrong english. - Original Message - From: "Richard Huxton" To: "NTPT" <[EMAIL PROTECTED]> Cc: "

[GENERAL] Filesystem level backup and 32 / 64 bit

I have situation where I have one box with linux native 64 bit distribution (Gentoo on AMD) running pg 8.x and other box running a 32 bit distro running version of pg 8.x Is it posssible to take a "filesystem level backup" (copyiing all in $PGDATA directory) from 64 bit system and use it as $

[GENERAL] \dt gives ERROR: did not find '}' at end of input node

Please I need help   I receive the following error trying to do \dt  or  \di command in psql. What is wrong and how it can be fixed  ?   Data in this database are several GB and are vital for me ...    

[GENERAL] MULE_INTERNAL translation to win1250

Hi. I have a strange problem in postgres 8.1.4 (gentoo 64bit on AMD64 platform) My database is created vith LATIN-2 encoding for correct vieving of nacional specific characters ( czech language ) inside code of my php application is setting client encoding to win1250 because I need outpu

Re: [GENERAL] MULE_INTERNAL translation to win1250

e 16bit one ) but I am not able to reproduce this behavior on fresh table using "insert" and "select" statements. Please give me a some tip where to search and what else informations to provide. thank you. - Original Message - From: "Tom Lane" <

[GENERAL] Exact or less specific match ?

Hi. i have table like this: create table my_data ( cond_1 int8,cond_2 varchar(),cond_3 cond_n whatrver ,data text) This table represents a simple tree structure with known max level (n) . This table is filled with data, but branches have not a same depth. Now I need to select from table sel

[GENERAL] Postgresql and Athlon64 ?

Will I have some advantages, better performance etc using postgres 7.4 or postgres 8.x on Athlon64 system with 64 bit Linux distro ?Are there asome benchmark available or someone  personal experience ?       Or should I stay in 32 bit platform  for a while ?   Thanx for help  

Re: [GENERAL] Postgresql and Athlon64 ?

So postgresql can have benfit from 64 bit architecture ? - Original Message - From: "P.J. "Josh" Rovero" <[EMAIL PROTECTED]> To: "NTPT" <[EMAIL PROTECTED]> Cc: "'PgSql General'" Sent: Monday, January 31, 2005 2:33 PM Subjec

[GENERAL] How many connections now ?

Is there a way to determine how many connections to the database are active ? some form of select ? ie how many client application are connected to server ? I need this value for client application ... Thank for help. ---(end of broadcast)---

[GENERAL] More concurent transaction over single connection ?

AFAIK (7.4.x) there is one limitation in persistant connections to postgresql from various frontends ( http://cz.php.net/manual/en/features.persistent-connections.php ), because it can not use transactions in situation where more concurent tasks use a single connection (execuse my wrong english

[GENERAL] Touch row ?

is it possible to add column to database, that will automatically contain date+time (or likely Unix timestamp) when the row was touched/changed - ie by INSERT or UPDATE ? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the un

Re: [GENERAL] Specifying many rows in a table

- Puvodní zpráva - Od: "Steve Atkins" <[EMAIL PROTECTED]> Komu: <[EMAIL PROTECTED]> Odesláno: 28. ledna 2004 20:32 Predmet: [GENERAL] Specifying many rows in a table > I have a large table (potentially tens or hundreds of millions of rows) and > I need to extract some number of these ro

[GENERAL] Numbering a records

I have this table content (id int8,owner int8,position int8,timestamp int8,description text,batch int8) Table is inserted/deleted frequently, 'id' is almoust random. I insert to the table following set of rows : 12345, 1000,1,timestamp,blabla,0 12349, 1000,2,timestamp,blabla,0 12355, 1001,

[GENERAL] Relocation error pg_dumpall undefined symbol get_progname in 7.4.3

Regardi   I recently compile Postgresql 7.4.3 with gcc 3.4.0 on RH 7.3 . Regression tests work well All passed, but   Some binaries report a relocation error: :pg_dumpall undefined symbol get_progname .   This error occures in most of the binaries. What is wrong  ?  

Re: [GENERAL] Index on TEXT versus CHAR(32)... fast exact TEXT matching

what about to use a CRC32 checksum of the text, computed by client application an then make index of crc32 data ? ie add column crc int4, add column md5 varchar(255 ) create index blabla on mytable (crc) or even create index blabla2 on mytable (crc,md5) and query like . where crc='crc