Re: [GENERAL] ECPG and COPY

Am Freitag, 24. Februar 2006 05:26 schrieb Wes: > I found this in the archives: > > > > With 8.x, is it still true that with ECPG, it is not possible to use COPY > inline - I'd have to write the data to a file, then 'COPY FROM

[GENERAL] unsubscribe

unsubscribe

Re: [GENERAL] Temporal Databases

On Fri, 2006-02-24 at 00:20 -0300, Rodrigo Sakai wrote: > It's a good solution, but not what I'm looking for. > I'm looking for something implemented inside the database, like the > flashback functionality of oracle 10g. I think you need to be clear about why you want this: do you want this as a

[GENERAL] How to read odbc and pgadmin lists from news server

In previous week the following (and other active) newsgroups are removed from news.postgresql.org news server witohut any notice pgsql.interfaces.odbc pgsql.interfaces.pgadmin.hackers How to read those newsgroups from from news server ? Andrus. ---(end of broadcast

[GENERAL] How to load 6 MB file to database

I'm using Postgres 8.1 and latest ODBC driver in Windows XP with 256 MB RAM. When trying to insert a 6 MB binary file to a bytea field, out-of-memory error is writeen to ODBC log file and insert fails. Smaller files are inserted OK Any idea how to load 6 MB file to a bytea field or avoid out-o

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

Leonard Soetedjo wrote: > On Wednesday 15 February 2006 01:38, Tom Lane wrote: > > merlyn@stonehenge.com (Randal L. Schwartz) writes: > > > Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the > > > "other" way that MySQL could have transactions if Oracle decided to > > > restric

Re: [GENERAL] Does PG really lack a time zone for India?

Martijn van Oosterhout wrote: > Comments inline. > > On Wed, Feb 15, 2006 at 09:49:57AM -0500, Tom Lane wrote: > > I think defining the problem as "let's get rid of australian_timezones" > > would be a serious mistake. The basic problem here is that we can't > > have a one-size-fits-all list of t

Re: [GENERAL] incremental backups

I have applied the following patch adds to the paragraph after the one you quoted below. I just added mention that the start/stop time _and_ wal file names are in the history file. --- Rick Gigger wrote: > I've started writ

[GENERAL] Operator for int8 array

Dear All, I need operator for int8 array. I tried changing the code in contrib/ and compiled. When I tried executing the query, it is dumping. Kindly tell me if there is alternative to overcome the problem. I am using postgresql 7.1.3 version. -- regards, Deepa K ---(

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

On Fri, 24 Feb 2006, Bruce Momjian wrote: Leonard Soetedjo wrote: On Wednesday 15 February 2006 01:38, Tom Lane wrote: merlyn@stonehenge.com (Randal L. Schwartz) writes: Oracle purchases Sleepycat. From what I understand, BerkeleyDB was the "other" way that MySQL could have transactions if O

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

On Fri, Feb 24, 2006 at 10:52:53 -0400, "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > On Fri, 24 Feb 2006, Bruce Momjian wrote: > > Greatbridge had "major funding", and succeeded in burning it off in, what, > 12 months? It's been a long time, but I thought they still had a significant amount

[GENERAL] setting LC_NUMERIC

Hi, unfortunately I did not set the locales correct, when I created my database. The result is, that the numeric type expects an american format like "12.34". Since I'm from europe, where this number will be represented as "12,34" I would like to change it without having to recreate the database,

Re: [GENERAL] How do I use the backend APIs

Thanks Martijn. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] Could DBmirror be done with the mechine using RPM installation instaed of souce code [tar.gz] ?

I use the two  mechines with FC3 and postgresql 8.1 RPM installation and would like to do DBmirror or other postgresql database replication from master to slave server . Could I do this replication using RPM or I must use the tar.gz version ? Could anybody suggest me about replication? Amrit

[GENERAL] psql is very slow

Hi all,   I have a psql 7.3.4, apache 2.0.40, perl  v5.8.0. Database is pretty big, (dump is about 100Megs). But all the operations are very, very slow. Is any possibility to make postgresql more quick? (don't tell me to cut the database :))   OS version: 2.4.20-gentoo-r7 RAM: 512MB CPU:i686 AMD At

[GENERAL] How do I prevent binding to TCP/IP port outside of localhost?

I have a situation where I need postgres to LISTEN and allow BINDs to its TCP/IP port (5432) only to connections that originate from localhost. I need it to not accept *socket* connections if requests come in from off-box. If I try to set up pg_hba.conf such that it rejects off-box requests,

[GENERAL] User groups

Any user groups in the Tampa, St. Petersburg, Florida area? Anyone interested in starting a group? I am new to PostgreSQL and many aspects of programming, but I would very much like to meet with those that have the same interests, regardless of programming skills. ---(

Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

[EMAIL PROTECTED] napisał(a): > Could anybody point to an on-line resource about the steps involved with > upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum > downtime (i.e. 1 - stop db so that no changes happen 2 - dump 3 - > upgrade (ports) 4 - import 5- start db). > here you

[GENERAL] Lista de correo

Escribo en esta oprtunidad para unirme a la lista de correos de postgressql , estoy comenzando a usarlo, y me interesaria recibir documentacion que fuese util para mi, asi como tambien ayudar a quienes lo necsiten, siempre y cuando este a mi alcance... si me pueden recomendar algunos textos tambien

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

Marc G. Fournier wrote: On Fri, 24 Feb 2006, Bruce Momjian wrote: MySQL already has major funding. I don't see how it could get worse for us if Oracle bought them. I think that Leonards point here is that if Oracle were to acquire them and market MySQL as 'the low-end alternative', that the

Re: [GENERAL] How do I prevent binding to TCP/IP port outside of localhost?

if its linux, use iptables to block to port. -- Original Message --- From: Karl Wright <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: Thu, 23 Feb 2006 15:49:09 -0500 Subject: [GENERAL] How do I prevent binding to TCP/IP port outside of localhost? > I have a situation

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

Bruno Wolff III <[EMAIL PROTECTED]> writes: > "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: >> Greatbridge had "major funding", and succeeded in burning it off in, what, >> 12 months? > It's been a long time, but I thought they still had a significant amount > of money left when Greatbridge was

[GENERAL] checksum error from windows to linux

Hi all, I'm a newbie to postgres, and I'm facing a few problems to start my postgres server. Actually, I've retrieved a postgreSQL database from a postgreSQL server that was running on windows and I'm trying to load this database on a postgreSQL server that will be running on a linux mandrake platf

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

Without going into the particulars, let's just say the total amount spent was less than publicly announced figures, and the parent (sole investor) shut it down before coming close to those figures. Bruno Wolff III wrote: On Fri, Feb 24, 2006 at 10:52:53 -0400, "Marc G. Fournier" <[EMAIL PRO

Re: [GENERAL] psql is very slow

On 2/22/06 10:23 AM, "Michal Merta" <[EMAIL PROTECTED]> wrote: > I have a psql 7.3.4, apache 2.0.40, perl v5.8.0. Database is pretty big, > (dump is about 100Megs). > But all the operations are very, very slow. > Is any possibility to make postgresql more quick? (don't tell me to cut the > dat

Re: [GENERAL] How do I prevent binding to TCP/IP port outside of

Karl Wright wrote: I have a situation where I need postgres to LISTEN and allow BINDs to its TCP/IP port (5432) only to connections that originate from localhost. I need it to not accept *socket* connections if requests come in from off-box. If I try to set up pg_hba.conf such that it reject

Re: [GENERAL] upgrade PostgreSQL 8.x on production FreeBSD

Hi, If the downtime is a concern, you could use Slony-1 for the migration. Philippe Ferreira. [EMAIL PROTECTED] napisał(a): Could anybody point to an on-line resource about the steps involved with upgrading of PostgreSQL 8.x on a production FreeBSD 5.4 with minimum downtime (i.e. 1 - stop

Re: [GENERAL] checksum error from windows to linux

Antoine PERENNEC <[EMAIL PROTECTED]> writes: > Actually, I've retrieved a postgreSQL database from a postgreSQL > server that was running on windows and I'm trying to load this > database on a postgreSQL server that will be running on a linux > mandrake platform. You generally can't transfer the p

Re: [GENERAL] setting LC_NUMERIC

"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > How do I change the numeric format? You don't. You can use to_char and to_number to do locale-aware transformations, but the base data types only handle the SQL-standard representations of numbers. regards, tom lane -

Re: [GENERAL] psql is very slow

am 22.02.2006, um 16:23:16 +0100 mailte Michal Merta folgendes: > Hi all, > > I have a psql 7.3.4, apache 2.0.40, perl v5.8.0. Database is pretty big, > (dump is about 100Megs). > But all the operations are very, very slow. - 7.3 is very, very old, newer verions are much faster! - runs vacuum!

Re: [GENERAL] setting LC_NUMERIC

Am Mittwoch, 22. Februar 2006 14:26 schrieb [EMAIL PROTECTED]: > unfortunately I did not set the locales correct, when I created my > database. The result is, that the numeric type expects an american > format like "12.34". You can't change that. The locale only affects the to_char function. --

Re: [GENERAL] Temporal Databases

Simon Riggs wrote: A much easier way is to start a serialized transaction every 10 minutes and leave the transaction idle-in-transaction. If you decide you really need to you can start requesting data through that transaction, since it can "see back in time" and you already know what the snapsho

[GENERAL] ltree + gist index performance degrades significantly over a night

PostgreSQL 8.1.3 I'm trying to collect some hard numbers to show just how much it degrades and over how long a time interval. All I have now is anecdotal evidence, and I was hoping to save myself some downtime by seeking advice early. I have a search table which I use for partial-match text sear

Re: [GENERAL] pg_dump warning with -Fc option

Carlos Henrique Reimer wrote: Hello, Pg_dump complains when I use the -Fc option with: pg_dump: [archiver] WARNING: requested compression not available in this installation -- archive will be uncompressed and the dump is not compressed... searching in the list I´ve found that ther

Re: [GENERAL] Operator for int8 array

"K.Deepa" <[EMAIL PROTECTED]> writes: > I need operator for int8 array. I tried changing the code in contrib/ > and compiled. > When I tried executing the query, it is dumping. Kindly tell me if there > is alternative > to overcome the problem. I am using postgresql 7.1.3 version. 7.1.3? Egad.

Re: [GENERAL] Temporal Databases

[EMAIL PROTECTED] (Bernhard Weisshuhn) writes: > On Thu, Feb 23, 2006 at 03:34:36PM -0300, Rodrigo Sakai <[EMAIL PROTECTED]> > wrote: >> I'm focus on temporal databases (not temporary), and I want to know >> if anyone here is studying this tecnologies too. So, we can >> exchange knowlegment. Speci

Re: [GENERAL] ltree + gist index performance degrades

On Fri, 2006-02-24 at 11:02, CG wrote: > PostgreSQL 8.1.3 > > I'm trying to collect some hard numbers to show just how much it degrades and > over how long a time interval. > > All I have now is anecdotal evidence, and I was hoping to save myself some > downtime by seeking advice early. > > I ha

[GENERAL] collation & UTF-8

I'm using PosgreSQL 8.1.2 on linux and want to load UTF-8 encoded varchars.While I can store and get at stored text correctly, the ORDER BY places all accented characters (Croatian, in this case - probably marked hr_HR) after non-accented characters. This is no showstopper, but it does affect the g

Re: [GENERAL] collation & UTF-8

On Fri, Feb 24, 2006 at 06:23:07PM +0100, Tomi NA wrote: > I'm using PosgreSQL 8.1.2 on linux and want to load UTF-8 encoded varchars. > While I can store and get at stored text correctly, the ORDER BY places all > accented characters (Croatian, in this case - probably marked hr_HR) after > non-acc

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

On Fri, Feb 24, 2006 at 09:02:04AM -0800, CG wrote: > PostgreSQL 8.1.3 > > I'm trying to collect some hard numbers to show just how much it degrades and > over how long a time interval. > > All I have now is anecdotal evidence, and I was hoping to save myself some > downtime by seeking advice ear

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

--- Scott Marlowe <[EMAIL PROTECTED]> wrote: > Are you vacuuming regularly, are your fsm settings high enough, and what > does vacuum verbose say? Autovacuum is running, but I do a nightly vacuum analyze. When I just do a vacuum analyze on the table I get: data=# vacuum analyze verbose search; I

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

--- Martijn van Oosterhout wrote: > That's very odd. Like the other person said, do you vacuum and analyse? > But my question is: is it using the index? What does EXPLAIN / EXPLAIN > ANALYZE tell you? data=# explain select * from search where search_vector ~ '*.o.r.l.*'::lquery;

Re: [GENERAL] collation & UTF-8

On 2/24/06, Martijn van Oosterhout wrote: On Fri, Feb 24, 2006 at 06:23:07PM +0100, Tomi NA wrote:> I'm using PosgreSQL 8.1.2 on linux and want to load UTF-8 encoded varchars.> While I can store and get at stored text correctly, the ORDER BY places all > accented characters (Cro

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

CG <[EMAIL PROTECTED]> writes: > INFO: index "search_vector_idx" now contains 1344672 row versions in 47725 > pages > INFO: "letter_search": found 9 removable, 1344661 nonremovable row versions > in 33984 pages Yikes ... the index is bigger than the table! Seems like you've not been vacuuming

Re: [GENERAL] collation & UTF-8

Tomi NA <[EMAIL PROTECTED]> writes: > You were right about this: > LC_ALL=3Dhr_HR.UTF-8 sort < test.txt > (seemingly) collates the same way that pgsql does. Accented letters at the > end of the alphabet. I've tried hr_HR.UTF8 as well, without results. If you're not sure what locales are available

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

Bruno Wolff III wrote: > On Fri, Feb 24, 2006 at 10:52:53 -0400, > "Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > On Fri, 24 Feb 2006, Bruce Momjian wrote: > > > > Greatbridge had "major funding", and succeeded in burning it off in, what, > > 12 months? > > It's been a long time, but I thou

[GENERAL] Backup file extension

I am writing a client GUI application and am adding backup/restore features.  I noticed that different backup file extensions are used for PostgreSQL - pgAdmin uses .backup (possible problem because it is not consistent with 8.3 file names) and PG Lightning Admin uses .bak (possible problem

Re: [GENERAL] Backup file extension

On Fri, 2006-02-24 at 12:15, Michael Schmidt wrote: > I am writing a client GUI application and am adding backup/restore > features. I noticed that different backup file extensions are used > for PostgreSQL - pgAdmin uses .backup (possible problem because it is > not consistent with 8.3 file names

Re: [GENERAL] ltree + gist index performance degrades significantly over a night

On Fri, Feb 24, 2006 at 09:44:37AM -0800, CG wrote: > > > --- Martijn van Oosterhout wrote: > > > That's very odd. Like the other person said, do you vacuum and analyse? > > But my question is: is it using the index? What does EXPLAIN / EXPLAIN > > ANALYZE tell you? > > data=# explain select *

[GENERAL] phantom backends

I have a bunch of 7.4.6 backend processes that show up via pg_stat_get_db_numbackends(), pg_stat_get_backend_idset(), etc, but do not show up in ps. Any clues? Thanks, Ed ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] How much clustered?

Tom Lane wrote: > Carlos Henrique Reimer <[EMAIL PROTECTED]> writes: > > I would like to know how much clustered is a table related to some > > index How can I discover? > > You could do > select ctid from mytable order by indexcolumns > and then do whatever sort of calculation strike

[GENERAL] Requesting LinuxWorld East staffers

Hello, We need booth staffers for Linux World east. Please step up. Joshua D. Drake -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - h

Re: [GENERAL] Requesting LinuxWorld East staffers

Joshua D. Drake wrote: > Hello, > > We need booth staffers for Linux World east. Please step up. I think I am going. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---(

[GENERAL] Wrong length of bytea field

I inserted two binary files to a bytea field "contents" file1 size was 7834649 bytes file2 size was 5888534 bytes select filename, octet_length(contents), length(contents) from localfil returns "file1 ";16777184;16777184 "file2 ";157688

Re: [GENERAL] Wrong length of bytea field

On Fri, Feb 24, 2006 at 10:32:58PM +0200, Andrus Moor wrote: > It seems that for some reason postgres returns sometimes escaped string size > (eq. single byte 0x00 uploaded as \\000 size is returned as 5 ) I'd guess that "some reason" is because the data was over-escaped when it was inserted -- t

[GENERAL] How to tell how much of the database is being used for data.

Title: How to tell how much of the database is being used for data. Question: How can I tell how much free space is in the database itself? Background: We want to keep as many records as possible in the database as possible.  Currently we fill the database until the disk usage reaches 80

Re: [GENERAL] Requesting LinuxWorld East staffers

Joshua. > We need booth staffers for Linux World east. Please step up. Is that for Command Prompt or postgreSQL? Both, probably. I'm confused about Linux World east, though. I googled it and it looks like it was in Boston last month. brew ===

Re: [GENERAL] Requesting LinuxWorld East staffers

[EMAIL PROTECTED] wrote: Joshua. We need booth staffers for Linux World east. Please step up. Is that for Command Prompt or postgreSQL? Both, probably. It it is for PostgreSQL.Org. "I" am coordinating the booth. I'm confused about Linux World east, though. I googled it and

[GENERAL] "...unknown user name or bad password" error during install

Hi,I am trying to install PostgreSQL 8.1.3 on windows xp. This computer had previous versions of postgresql installed but they have been uninstalled.When the installer reach the window Service Configuration, I keep the default values  and add a password. I am getting the error: "Invalid username sp

[GENERAL] Another perplexity with PG rules

I'm stumped on the following problem. Everything between the "---" rows should be executable. Please advise. ~ TIA ~ Ken --- -- Here's a table: CREATE TABLE public.person_h ( person_id bigint DEFAULT nextval('pop_seq'::text), effective_date_and_time timestamptz DEFAULT ('now

Re: [GENERAL] How to specify infinity for intervals ?

Karsten Hilbert wrote: > Thanks to all for the suggestions. > > For the time being I will stay with using NULL. > > I will also stay with the hope that one day before long we > will have "'infinite'::interval". We have this TODO: o Allow infinite dates just like infinite timestamps Do

Re: [GENERAL] psql is very slow

Oops! [EMAIL PROTECTED] ("Michal Merta") was seen spray-painting on a wall: > I have a psql 7.3.4, apache 2.0.40, perl  v5.8.0. Database is pretty > big, (dump is about 100Megs). > > But all the operations are very, very slow. > > Is any possibility to make postgresql more quick? (don't tell me to

Re: [GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR: syntax

[EMAIL PROTECTED] wrote: > I'm relatively new to database programming & I've inherited a system to > maintain that contains lots of embedded SQL. I'm attempting to port my C > source code from RH 7.2 (with ecpg 2.8.0) to Mandrake 10.0 (with ecpg > 4.1.1). ecpg 4.1.1 is generating an error which

Re: Fw: [GENERAL] ecpg error --> DbPg_cre_sect_buf.pgc:1334: ERROR:

[EMAIL PROTECTED] wrote: > > > > > > >I think you should omit the word "RELEASE" after the > > "ROLLBACK". > > Will this still result in the closed DB connection that the "ROLLBACK > RELEASE" used to give me? No, it will not. I see way to do that anymore using a single statement. --

Re: [GENERAL] phantom backends

Oops! [EMAIL PROTECTED] ("Ed L.") was seen spray-painting on a wall: > I have a bunch of 7.4.6 backend processes that show up via > pg_stat_get_db_numbackends(), pg_stat_get_backend_idset(), etc, > but do not show up in ps. Any clues? Possibly your statistics collector got "overrun," and the la

Re: [GENERAL] Requesting LinuxWorld East staffers

Quoth [EMAIL PROTECTED]: > Joshua. > >> We need booth staffers for Linux World east. Please step up. > > Is that for Command Prompt or postgreSQL? Both, probably. > > I'm confused about Linux World east, though. I googled it and it looks > like it was in Boston last month. It could be one of

Re: [GENERAL] Backup file extension

After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Michael Schmidt") belched out: > I am writing a client GUI application and am adding backup/restore > features.  I noticed that different backup file extensions are used > for PostgreSQL - pgAdmin uses .backup (possible problem because

Re: [GENERAL] Error correction to FAQ

Updated. Thanks. I forgot that was up there. --- Harald Armin Massa wrote: > Within the FAQ, Point 4.5 there is: > > []The size of the PostgreSQL database file containing this data can be > estimated as 6.4 MB: > > >

Re: [GENERAL] Requesting LinuxWorld East staffers

Christopher Browne wrote: Quoth [EMAIL PROTECTED]: Joshua. We need booth staffers for Linux World east. Please step up. Is that for Command Prompt or postgreSQL? Both, probably. I'm confused about Linux World east, though. I googled it and it looks like it was in Boston

Re: [GENERAL] ECPG and COPY

Michael Meskes wrote: > Am Freitag, 24. Februar 2006 05:26 schrieb Wes: > > I found this in the archives: > > > > > > > > With 8.x, is it still true that with ECPG, it is not possible to use COPY > > inline - I'd have to write

Re: [GENERAL] How to specify infinity for intervals ?

On Feb 25, 2006, at 12:09 , Bruce Momjian wrote: We have this TODO: o Allow infinite dates just like infinite timestamps Do we need to add intervals to this? I think to be consistent with the other datetime types, might as well. Then one would be able to get an answer to test=#