Re: [GENERAL] Need help on "org.postgresql.util.PSQLException: FATAL:

Wong Jowo wrote: Hello,I'm using JSP for accessing postgre My postgre version is 8.1 running on suse enterprise 10 linux machine. My JSP container is Apache Tomcat 5.5. My connection method is JNDI(pooling). Recently I'm having trouble after my web application is being accessed by many users. My

Re: [GENERAL] need help with plpgsql execute insert

[EMAIL PROTECTED] wrote: I believe you are wrong. the EXECUTE is being given 11 columns, it expects 1. I think you need to form your execute query like; EXECUTE 'INSERT INTO payment ( id,amount,accepted_date, company_id , date , patient_responsible_party_id patient_contact_responsible_part

[GENERAL] Broken link on website...

Hi all, Should be posting this to pgsql-www but since I don't have subscription there, hence posting it here. Upon submitting a bug from the 'Support' link, I was redirected to the following page. Here, clicking on 'Return to the original page', leads t

Re: [GENERAL] Changing passwords from client application

On Tue, 19 Dec 2006, Tomasz Ostrowski wrote: > - it will be possible to use for example a left open psql session to > change password of logged in user without knowledge of previous > password. Forget it - I just found on http://www.postgresql.org/docs/8.2/static/sql-alterrole.html "Ordinary

[GENERAL] Password strength requirements

I'm working on a project which needs to satisfy some legal requirements for password strength. But any postgresql user can do; alter role [session_user] password 'foo'; Is there any way to disallow self changing of password by ordinary users? Or force password strength in any other way? R

[GENERAL] PG 8.2.0 - TSearch2 "Wrong affix file format"

Hi! I have a problem migrating my Database using TSearch2 with the UTF-8 Backport from 8.1.3 to a new database with 8.2.0. I successfully installed postgres and the TSearch2 distributed with it and copied the german.aff/german.med/german.stop and german.stop.ispell from my old postgre

[GENERAL] 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...

With a database loaded into 8.2.0 from a dump from an 8.1.4 server, "\df+ foo()", where foo()'s body has embedded tabs shows up with those tabs escaped, whereas under 8.1.4 they were emitted verbatim: Is there a trick to getting old behaviour back? It seems to happen regardless of client_e

Re: [GENERAL] 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...

On Thu, Dec 21, 2006 at 10:25:02AM -0500, James Robinson wrote: > With a database loaded into 8.2.0 from a dump from an 8.1.4 server, > "\df+ foo()", where foo()'s body has embedded tabs shows up with > those tabs escaped, whereas under 8.1.4 they were emitted verbatim: It's part of the align

Re: [GENERAL] Need help on "org.postgresql.util.PSQLException: FATAL:

Please cc: the mailing list - that lets everybody help. Wong Jowo wrote: The postgres error message is the same : FATAL: terminating connection due to administrator command But in log I saw that ther is on kind of error that happened before the "FATAL: terminating connection due to administrat

[GENERAL] Website Hosting Service and Security

Does anyone recommend a Website Hosting Service that supports PostgreSQL databases, Java, and Java Server Pages? Also does anyone recommend a low budget security method to support logging into an application? I'm writing a web application using Java that I want to use with a PostgreSQL databas

Re: [GENERAL] PG 8.2.0 - TSearch2 "Wrong affix file format"

Send to me dict and aff file, pls By the way, tsearch2 is changed significantly, so, the better way to update is a restoring only your data&schema. Tsearch2 should be installed from contrib. Tarabas (Manuel Rorarius) wrote: Hi! I have a problem migrating my Database using TSearch2 with the

Re: [GENERAL] PG 8.2.0 - TSearch2 "Wrong affix file format"

Hi, TS> Send to me dict and aff file, pls see attached .aff file, I have not created the file from a dict myself but taken the .aff/.med/.stop/.stop.ispell from this blog: http://www.tauceti.net/roller/cetixx/category/Tipps ... TS> By the way, tsearch2 is changed significantly, so, the better w

Re: [GENERAL] 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...

Many thanks! \a before \df+ does the trick. James On Dec 21, 2006, at 10:31 AM, Martijn van Oosterhout wrote: Well, in unaligned mode it's still the old way. There was some discussion at the time about whether tabs should be converted to spaces on output, but I don't think that got anywher

[GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

Hi all, I'm having some troubles with time zones! I have a database dump file that have the date fields stored as '2006-12-20 00:00:00-02'! And I have to restore it in a database that has the time zone configured as 'BRST' (-3 from GMT). So, when it is restored the value becomes '2006-12-19 2

Re: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

'2006-12-20 00:00:00-02' and '2006-12-19 23:00:00-03' *are* the same time. You *did* preserve it. Is your application unaware of timezone? If you want the server to behave like it's in a different time zone that where it actually is, configure the locale in postgresql.conf. http://www.postgresq

[GENERAL] Compiling PL/R library on win32

Hello list, Last night I was finally able to compile in MinGW the PL/R module for using R stats in PostgreSQL. I describe how I did this here: http://gborg.postgresql.org/pipermail/plr-general/2006-December/000183.html. However, as I mention in that post, it seems that the dll doesn't want to w

Re: [GENERAL] Autovacuum Improvements

Russell Smith wrote: Alvaro Herrera wrote: I intend to work on the maintenance window idea for 8.3. I'm not sure if I'll be able to introduce the worker process stuff in there as well. I actually haven't done much design on the stuff so I can't say. What does a maintenance window mean? I a

[GENERAL] TSearch2 Changeset 25387

http://projects.commandprompt.com/public/pgsql/changeset/25387 Though I'm probably start going on Oleg's nerves.. :/ I'm still trying to get compound word support for my dictionaries back, while migrating from 8.1.5-gin-utf8 to 8.2. Can someone give me additional information on that change? M

Re: [GENERAL] PG 8.2.0 - TSearch2 "Wrong affix file format"

Affix file has artifact: PFX G N 1 .> GE which is strange mix of openoffice format and ispell format. Just remove they. 8.2 Ispell code checks format strongly that in previous versions, even backported :) Tarabas (Manuel Rorarius) wrote: Hi, TS> Send to me dict and aff file, pls see

Re: [bulk] Re: [GENERAL] PG 8.2.0 - TSearch2 "Wrong affix file format"

thanks, that fixed it :-) Best regards Manuel TS> Affix file has artifact: TS> PFX G N 1 TS> .> GE TS> which is strange mix of openoffice format and ispell format. Just remove they. TS> 8.2 Ispell code checks format strongly that in previous versions, even backported :) --

Re: [GENERAL] TSearch2 Changeset 25387

Are you trying to convert openoffice (myspell) format to ispell with help of my2ispell? It seems to me, I see the problem. m2ispell doesn't convert prefixes which can not be combined with every word ('N' in myspell). So, ispell file will contain wrong line begining with PFX... I'll fixed tha

Re: [GENERAL] TSearch2 Changeset 25387

What version of OpenOffice MySpell dictionaries is supposed to work with TSearch in 8.2? The format used till OpenOffice 2.0.1 or the format starting from 2.0.2? -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 2: Don't 'kill -9' the post

Re: [GENERAL] Autovacuum Improvements

On Thu, 2006-12-21 at 18:03, Matthew T. O'Connor wrote: > The maintenance window design as I understand it (Alvaro chime in if I > get this wrong) is that we will be able to specify blocks of time that > are assigned specific autovacuum settings. For example we might define > a maintenance wind

RES: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

Actually I want the server to behave in the time zone 'BRST' (this is already configured). But the machine where the dump was done was with a time zone that is -2 from GMT! So I need to restore this dump in my server, but maintain the 00:00:00 at the hour part! Is there a way??? -Mensage

Re: [GENERAL] Password strength requirements

On Dec 21, 2006, at 7:08 AM, Tomasz Ostrowski wrote: I'm working on a project which needs to satisfy some legal requirements for password strength. But any postgresql user can do; alter role [session_user] password 'foo'; Is there any way to disallow self changing of password by ordina

Re: [GENERAL] TSearch2 Changeset 25387

Hmm, 2.0.1. But what's the difference? I don't watch changes in OpenOffice hardly. Hannes Dorbath wrote: What version of OpenOffice MySpell dictionaries is supposed to work with TSearch in 8.2? The format used till OpenOffice 2.0.1 or the format starting from 2.0.2? -- Teodor Sigaev

Re: [GENERAL] Autovacuum Improvements

> I intend to work on the maintenance window idea for 8.3. I'm not sure > if I'll be able to introduce the worker process stuff in there as well. > I actually haven't done much design on the stuff so I can't say. Something to consider, per-day maintenance windows, where Sat & Sun could have 24-ho

Re: [GENERAL] TSearch2 Changeset 25387

On 21.12.2006 18:32, Teodor Sigaev wrote: Are you trying to convert openoffice (myspell) format to ispell with help of my2ispell? Yes: http://groups.google.com/group/pgsql.general/browse_thread/thread/c21872aca3754a06/3a909c0e1f05a5af I'm really unsure what someone is supposed to do, to get c

Re: [GENERAL] Autovacuum Improvements

Csaba Nagy wrote: > On Thu, 2006-12-21 at 18:03, Matthew T. O'Connor wrote: > > The maintenance window design as I understand it (Alvaro chime in if I > > get this wrong) is that we will be able to specify blocks of time that > > are assigned specific autovacuum settings. For example we might de

Re: [GENERAL] need help with plpgsql execute insert

> [EMAIL PROTECTED] wrote: >>> I believe you are wrong. the EXECUTE is being given 11 columns, it >>> expects 1. I think you need to form your execute query like; >>> >>> EXECUTE 'INSERT INTO payment ( >>> id,amount,accepted_date, company_id , date , >>> patient_responsible_party_id patient_c

Re: [GENERAL] TSearch2 Changeset 25387

Oh, I see. So, only 2.0.1 and I can't change that for 8.2 branch. :( Hannes Dorbath wrote: On 21.12.2006 18:32, Teodor Sigaev wrote: Are you trying to convert openoffice (myspell) format to ispell with help of my2ispell? Yes: http://groups.google.com/group/pgsql.general/browse_thread/thread/

Re: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

On Dec 21, 2006, at 11:32 , Rodrigo Sakai wrote: But I have to restore it and maintain the same value of datetime! How can I do it? You should have no problem. A timestamp with time zone marks an absolute instant in time: the different time zones are different representations of the s

Re: RES: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

Rodrigo Sakai wrote: Actually I want the server to behave in the time zone 'BRST' (this is already configured). But the machine where the dump was done was with a time zone that is -2 from GMT! So I need to restore this dump in my server, but maintain the 00:00:00 at the hour part! Is ther

[GENERAL] Partitioning Vs. Split Databases - performance?

I'm breaking up a database into several sets of data with similar layout. (we currently have multiple customers using a single database and tableset, we're splitting it out to give us more "wiggle room") It seems that there are basically two ways to proceed: 1) Copy out the data specific to a

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On Thu, 2006-12-21 at 11:10 -0800, Benjamin Smith wrote: > I'm breaking up a database into several sets of data with similar layout. (we > currently have multiple customers using a single database and tableset, we're > splitting it out to give us more "wiggle room") > > It seems that there are

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/21/06 13:17, Joshua D. Drake wrote: > On Thu, 2006-12-21 at 11:10 -0800, Benjamin Smith wrote: >> I'm breaking up a database into several sets of data with similar layout. >> (we >> currently have multiple customers using a single database and

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On 12/21/06, Ron Johnson <[EMAIL PROTECTED]> wrote: >> Given the same physical hardware, which one is likely to perform better? Does >> it make any difference? Does using separate databases use more RAM than a >> single database with a bunch of different tables? Config files are global, so I d

Re: [GENERAL] Password strength requirements

On Thu, 21 Dec 2006, Steve Atkins wrote: > >Is there any way to disallow self changing of password by ordinary > >users? Or force password strength in any other way? > > If you check > http://www.postgresql.org/docs/8.2/static/client-authentication.html > you'll see a bunch of different ways to

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On Thu, 21 Dec 2006, Vlad wrote: On 12/21/06, Ron Johnson <[EMAIL PROTECTED]> wrote: >> Given the same physical hardware, which one is likely to perform better? Does >> it make any difference? Does using separate databases use more RAM than a >> single database with a bunch of different tabl

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

I will also second that and if you got a lot of data, go for table partitioning as well but will not recommend dividing into different databases. - Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/22/06, Vlad <[EMAIL PROTECTED]> wrote: On 12/21/06, Ron Johnson <[EMAIL PROTE

Re: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES

So you want to change the time? I don't see why that's what you'd want to do, but: UPDATE mytable SET mydate = mydate + INTERVAL '1 hour'; That's the only way to make '2006-12-20 00:00:00-02' show up as '2006-12-20 00:00:00-03' if GMT-03 is the timezone your server is in, because those are compl

Re: [GENERAL] Password strength requirements

On Thu, Dec 21, 2006 at 21:04:33 +0100, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote: > > But I need an ability to change passwords. The easiest way to do it But do you have to use the native passwords in Postgres? If you use ldap or pam, you could use passwords maintained somewhere else that had

Re: [GENERAL] Website Hosting Service and Security

Brandon E Hofmann wrote: Does anyone recommend a Website Hosting Service that supports PostgreSQL databases, Java, and Java Server Pages? Also does anyone recommend a low budget security method to support logging into an application? I've never had anything hosted there, but several people i

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On Thursday 21 December 2006 11:47, Ron Johnson wrote: > This gives you linear growth potential, since if your current box > gets over-utilized, buy a 2nd box and move some of the databases to it. So far, I'm inclined to go this way, due to the option for linear scaling. > >> 2) Copy out the dat

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

> > > 3) Put each customer in their own schema/namespace which resides within > > > its own table space. > > > > > > Then you can move customers wherever you need in terms of IO. > > How is that functionally different than using a separate database? What's the > advantage here? I don't *need* to

Re: [GENERAL] Password strength requirements

On Thu, 21 Dec 2006, Bruno Wolff III wrote: > > But I need an ability to change passwords. > > But do you have to use the native passwords in Postgres? If you use > ldap or pam, you could use passwords maintained somewhere else that > had more strict requirements. As I've written earlier I'd hav

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/21/06 16:41, Joshua D. Drake wrote: 3) Put each customer in their own schema/namespace which resides within its own table space. Then you can move customers wherever you need in terms of IO. >> How is that functionally differe

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On Thu, 2006-12-21 at 16:54 -0600, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 12/21/06 16:41, Joshua D. Drake wrote: > 3) Put each customer in their own schema/namespace which resides within > its own table space. > > Then you can move customers

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On Thursday 21 December 2006 14:41, Joshua D. Drake wrote: >You should read up on schemas and how they work. Plus the > addition of schemas and table spaces means you can infinite scaling > within the confines of your hardware itself. Ok, so I'd like you to correct me if I'm wrong: 1) Schemas op

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/21/06 17:15, Joshua D. Drake wrote: > On Thu, 2006-12-21 at 16:54 -0600, Ron Johnson wrote: > On 12/21/06 16:41, Joshua D. Drake wrote: [snip] > This solution seems to have the same problems as using dynamic > tablenames. Not reall

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

Depending on what kind of company you have, you may (or may not) want to consider how you will upgrade the schema over time. Might it be the case that some customers will need a different schema than others? If so, a simple data partitioning by customer id probably won't be the best option. On

[GENERAL] 'Indirect' clustering?

We have a multi-tenant db with a lot of DDL along these lines: journal_entry ( id serial, tenant_id integer not null, entry_date datetime not null, description varchar(255), primary key (id), foreign key (tenant_id) references tenant (id) ); tx ( id serial, journal_entry_id integer not n

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

On Thu, 2006-12-21 at 15:22 -0800, Benjamin Smith wrote: > On Thursday 21 December 2006 14:41, Joshua D. Drake wrote: > >You should read up on schemas and how they work. Plus the > > addition of schemas and table spaces means you can infinite scaling > > within the confines of your hardware itself.

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

> >> Also if you spec the hardware correctly, you can get up to a total of 16 > >> cores without any significant cost... just add cpus as needed. > > > >> PostgreSQL 8.1 does extremely well up to 8 cpus (8 cores). 8.2 is said > >> to perform better on > 8 cores, but I have not tested it. > > Sur

[GENERAL] How could I get a win32/aix version of plruby?

I am using postgresql 8.2 and ruby 1.8.5. While I compiled plruby 0.5.0 on cygwin, the last step failed, some symbols in libpostgres.a were missing. And I do not know how to compile it with visual studio And on AIX 5.1, the compiling works, but failed on `make test`, pgmaster terminated on s

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/21/06 18:12, Joshua D. Drake wrote: Also if you spec the hardware correctly, you can get up to a total of 16 cores without any significant cost... just add cpus as needed. PostgreSQL 8.1 does extremely well up to 8 cpus (8 cores).

Re: [GENERAL] Directly programmed query plans?

On Dec 20, 2006, at 17:34 , Josh ben Jore wrote: I vaguely recall that there’s an interface to PostgreSQL 7.3 where developers can directly feed it query plans. Can someone help me remember where this lived and whether it worked? The problem I’m looking at is that it’s difficult to impos

[GENERAL] Best Perl DBI Driver for Postgres

Can anyone recommend a stable Perl DBI driver for Postgresql?   I'm using DBD::PgPP and it's limited to not using BLOB data and has a bug in it if you return only one filed.  Have a better suggestion?   Thanks Adam

[GENERAL] DBmirror

I would like to know whether I can set DBmirror replication from the fedora core 5_64 which postgresql8.1 was installed by rpm process not by compiling the source. All of the component include server, contrib, perl, test, doc, devel and lib were also rpm and what is the way to set it? Do I need to

Re: [GENERAL] Password strength requirements

Tomasz Ostrowski <[EMAIL PROTECTED]> writes: > And everything I need would be very simple to do if there was an > option to disable self-change of passwords for ordinary users. If you are using PAM authentication, the password recorded by Postgres is irrelevant, so I'm not seeing what the problem

Re: [GENERAL] Best Perl DBI Driver for Postgres

Try DBD::Pg. I don't know what OS you are using but if it is Windows and your perl package installation is by ActiveState, then last I checked DBD::Pg was not included with it. A ppm is available however. Mike On Thu, 2006-12-21 at 21:34 -0700, [EMAIL PROTECTED] wrote: > Can anyone recommend a

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

> >> With One Big Database, you can get a SAN and attach a whole lot of > >> disk space, but your mobo will only accept a certain number of DIMMs > >> and processors of certain designs. And when your growing mega > >> database maxes out your h/w, you're stuck. > > > > Define mega... Because you

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/21/06 23:44, Joshua D. Drake wrote: With One Big Database, you can get a SAN and attach a whole lot of disk space, but your mobo will only accept a certain number of DIMMs and processors of certain designs. And when your growing m

Re: [GENERAL] Website Hosting Service and Security

It looks like there is at least one PostgreSQL/Java hosting service on this list: http://www.postgresql.org/support/professional_hosting PostgreSQL supports secure connections. SSH is another common option for connecting remotely to PostgreSQL. On Dec 21, 2006, at 10:19 AM, Brandon E Hof

Re: [GENERAL] Password strength requirements

On Thu, Dec 21, 2006 at 23:43:06 +0100, Tomasz Ostrowski <[EMAIL PROTECTED]> wrote: > > And everything I need would be very simple to do if there was an > option to disable self-change of passwords for ordinary users. That seems like a feature not many other people are going to want. You have t

Re: [GENERAL] Partitioning Vs. Split Databases - performance?

Ron Johnson <[EMAIL PROTECTED]> writes: > Besides, since pg_dump is single-threaded, backing up a huge > database gets impossible. Federating the database allows multiple > pg_dumps to simultaneously dump data to multiple tape drives. ... as long as you don't care about having a self-consistent d