Re: [GENERAL] Reducing pg_dump & pg_restore times

Coder At Heart wrote: Hi! Restore & backup take time in the tune of 6 hrs on a Linux, 4 proc, 32 G RAM machine for a 60GB database. Please always cc the mailing list. I've never played with databases that large so I don't know if that's good or bad.. others on the list will be able to offe

Re: [GENERAL] Reducing pg_dump & pg_restore times

C.M. Shivkumar wrote: Hello all! I have databases of sizes ranging from 30-60GB that have to be backed-up and restored. I want to reduce the pg_dump and pg_restore times for the same. Can someone throw some light on how to go about it. I have tried tweaking the postgresql.conf properties. Tho

[GENERAL] Reducing pg_dump & pg_restore times

Hello all!I have databases of sizes ranging from 30-60GB that have to be backed-up and restored. I want to reduce the pg_dump and pg_restore times for the same. Can someone throw some light on how to go about it. I have tried tweaking the postgresql.conf properties. Though, I am not sure what each

Re: [GENERAL] pg_dumpall failing from possible corrupted shared memory

> > 10-25 18:51:43 PDT% LOG: server process (PID 12899) was > > terminated by signal 11 > > Stack trace from coredump, please? And exactly which PG version is > this? The version is 8.1.4 on: Linux version 2.6.17-gentoo-r7 ([EMAIL PROTECTED]) (gcc version 4.1.1 (Gentoo 4.1.1)) #8 Sun Oc

Re: [GENERAL] pg_dumpall failing from possible corrupted shared memory

Richard Broersma Jr <[EMAIL PROTECTED]> writes: > 10-25 18:51:43 PDT% LOG: server process (PID 12899) was > terminated by signal 11 Stack trace from coredump, please? And exactly which PG version is this? regards, tom lane ---(end of broad

[GENERAL] pg_dumpall failing from possible corrupted shared memory

I am trying to perform a complete dump of my database. However, I am getting an error when pg_dumpall reaches one particular database. I reformatted the text so that it wouldn't get chopped to pieces after it is sent. Here is the output from pg_dumpall: [EMAIL PROTECTED] $ pg_dumpall > test.d

[GENERAL] pg_dumpall failing

I am trying to preform a complete dump of my database. However, I am getting an error when pg_dumpall reachs one particular database. I reformated the text so that it wouldn't get chopped to pieces after it is sent. Here is the output from pg_dumpall: [EMAIL PROTECTED] $ pg_dumpall > test.dum

Re: [GENERAL] 8.2 release schedule

On Saturday 21 October 2006 13:51, Marek Lewczuk wrote: > Hello, > is there any schedule for final 8.2 release ? As far I remember this > should be around November ? I would like to know that in order to plan > my work. > Officially it will be released "when it is ready". Unofficially that will

[GENERAL] NOTICE: word is too long INSERT 0 3014

Hello, I am running into this limitation ALOT with Tsearch2. What are my options to get around it. Do I have to compile PostgreSQL with a different block size? If yes, what are the downsides to doing so (outside of not being able to do straight upgrades)? Sincerely, Joshua D. Drake --

Re: [GENERAL] Enableing contrib modules on Debian

"Stuart Grimshaw" <[EMAIL PROTECTED]> writes: > I've installed the postgresql-contrib8.1 deb package to get at the > earthdistance function, but it doesn't seem to be recognised, even > after a restart of the server. > Is there a final step I need to take after using apt-get to install? Yeah, you

Re: [GENERAL] password cookie

I think that´s not exactly what i´m looking for.Just to make sure that i understand what you´re proposing (please correct me if i´m wrong):I´ll write a function that will create a hash of username, password and, say 'now'::timestamp and store it in a cookie and in a separate table somewhere on the

[GENERAL] Enableing contrib modules on Debian

Hi, I've installed the postgresql-contrib8.1 deb package to get at the earthdistance function, but it doesn't seem to be recognised, even after a restart of the server. Is there a final step I need to take after using apt-get to install? -- -S Sports Photography in South Yorkshire & Derbyshire

[GENERAL] Compiling ELF 64-bit on Solaris

How can I get the "make" to generate ELF 64-bit executables on Solaris 10? We're on Fujitsu hardware; uname -a gives me: SunOS 5.10 Generic_118822-26 sun4us sparc FJSV,GPUZC-M Thanks ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postm

Re: [GENERAL] Problem with 8.1.5 RPMs for Redhat AS 4

The SRPM appears to be available: http://www.postgresql.org/ftp/binary/v8.1.5/linux/srpms/redhat/rhel-as-4 / -- Brandon Aiken CS/IT Systems Engineer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Will Reese Sent: Wednesday, October 25, 2006 2:42 PM To:

[GENERAL] Problem with 8.1.5 RPMs for Redhat AS 4

I tried installing the 8.1.5 RPMs, and I got a dependency error on the postgresql-server-8.1.5-2PGDG.i686.rpm file. The 8.1.4 rpms installed without a problem. I googled around and found this post... http://www.dbtalk.net/mailing-database-pgsql-bugs/bugs-8-1-5- rpms-338777.html It looks l

[GENERAL] Postgres history and the 30th Anniv. of Ingres, gathering at UCB...

Hello Postgresers, I don't know where better to post this, but feel free to forward this on elsewhere. I haven't seen anything on this posted in Postgres circles (though I might have missed it!), so I thought someone should. What follows is about two pages of PostgreSQL's (pre?) history (includ

Re: [GENERAL] DBI-Link, Oracle, database encoding

On Wed, Oct 25, 2006 at 03:47:20PM +0200, Albe Laurenz wrote: > Hannes Dorbath wrote: > > After some trouble we managed to get up DBI-Link between PG 8.1.5 > > and Oracle 9i. > > > > Oracle is on LATIN1 (I think) and the PG database runs on UTF8. We > > have some encoding problems with it. > > >

Re: [GENERAL] 8.2beta1 installation fails

> It would still be interesting to know if made a difference if you were > on the console, though Installation from console session is OK. > When this happens, can you run initdb manually? I mean while the error > message is up there? Just to show where the problem is. I'm unable to run initdb

Re: [GENERAL] Monitoring Postgres - Get the SQL queries which are sent to postgres

am Wed, dem 25.10.2006, um 15:56:17 +0200 mailte Nico Grubert folgendes: > Dear list members, > > I have a web application running that is connected to my postgres > database. This web application builds dynamically SQL queries and > queries the postgres database. I would like to see these SQL

Re: [GENERAL] Monitoring Postgres - Get the SQL queries which are sent to postgres

On 10/25/06, Nico Grubert <[EMAIL PROTECTED]> wrote: Dear list members, I have a web application running that is connected to my postgres database. This web application builds dynamically SQL queries and queries the postgres database. I would like to see these SQL queries. How can I do this? Is

Re: [GENERAL] password cookie

On Wed, Oct 25, 2006 at 03:49:54PM +0200, Willy-Bas Loos wrote: > So as a temporary compromise, we decided to store the username and password > in a cookie on the client PC, which is of course a serious weakness. > > Can anyone give me some advise on how to do this a better way, without > consumin

[GENERAL] Monitoring Postgres - Get the SQL queries which are sent to postgres

Dear list members, I have a web application running that is connected to my postgres database. This web application builds dynamically SQL queries and queries the postgres database. I would like to see these SQL queries. How can I do this? Is there a way to monitor the SQL queries which are s

[GENERAL] password cookie

Hi,I´m envolved in developping a website that will function as a frontend for psql 8.1 cluster.We use a number of frontend technologies, and we want to keep the authentication in the backend. Not a system where the frontend queries a table to verify username password, sets the priviliges on the fro

Re: [GENERAL] DBI-Link, Oracle, database encoding

Hannes Dorbath wrote: > After some trouble we managed to get up DBI-Link between PG 8.1.5 and > Oracle 9i. > > Oracle is on LATIN1 (I think) and the PG database runs on > UTF8. We have > some encoding problems with it. > > We tried setting NLS_LANG='american_america.AL32UTF8' for > Oracle, wh

[GENERAL] DBI-Link, Oracle, database encoding

After some trouble we managed to get up DBI-Link between PG 8.1.5 and Oracle 9i. Oracle is on LATIN1 (I think) and the PG database runs on UTF8. We have some encoding problems with it. We tried setting NLS_LANG='american_america.AL32UTF8' for Oracle, which works for SqlPlus, but not DBD::Ora

Re: [GENERAL] Difficulty passing in an array of values to EXECUTE

William Leite Araújo wrote: > > 2006/10/25, Richard Huxton mailto:dev@archonet.com>>: > > Nick Rowlands wrote: > > Hi there, > > > > I'm having trouble creating a function using plpgsql. I cannot > pass the > > array 'productids' to the ANY construct of the IN EXECUTE SELECT

Re: [GENERAL] Difficulty passing in an array of values to EXECUTE

2006/10/25, Richard Huxton : Nick Rowlands wrote:> Hi there,>> I'm having trouble creating a function using plpgsql. I cannot pass the> array 'productids' to the ANY construct of the IN EXECUTE SELECT> statement. Any ideas on what I'm doing wrong would be most appreciated. > Here'

Re: [GENERAL] Difficulty passing in an array of values to EXECUTE

Nick Rowlands wrote: Hi there, I'm having trouble creating a function using plpgsql. I cannot pass the array 'productids' to the ANY construct of the IN EXECUTE SELECT statement. Any ideas on what I'm doing wrong would be most appreciated. Here's the function: FOR row IN EXECUTE 'SELECT p

[GENERAL] Difficulty passing in an array of values to EXECUTE SELECT statement

Hi there, I'm having trouble creating a function using plpgsql. I cannot pass the array 'productids' to the ANY construct of the IN EXECUTE SELECT statement. Any ideas on what I'm doing wrong would be most appreciated. Here's the function: CREATE OR REPLACE FUNCTION search_products(metalparam int

Re: [GENERAL] 8.2beta1 installation fails

> Andrus, > > did you make sure you used the /console mode of remote desktop? > > > On 10/24/06, Andrus <[EMAIL PROTECTED] > wrote: > > I ran msi installation package downloaded from > postgresql.org from remote > desktop. > I selected Estonian locale