[ADMIN] PgAgent Job Scheduling-Backup

2007-07-10 Thread Jayakumar_Mukundaraju
Dear Vishal, I installed job scheduler in postgres windows xp box. I want to schedule a backup job for every day.Kindly give me the solution.. Thanks & Regards Jayakumar M From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Wed 7/11/2007 9:58 AM To: Jayakumar_Mu

Re: [ADMIN] PgAgent Job Scheduling

2007-07-10 Thread Vishal Arora
Kindly refer to pgadmin mailing list, I have a list of conversation there. http://www.pgadmin.org/archives/pgadmin-support/2007-06/index.php Let me know if you can not do it still _ Plesae put the proper subject in your mail so that it could be related. - vishal From: "Jayakumar_Mukundaraju

Re: [ADMIN] 8.2.4 patches?

2007-07-10 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Ray Stell wrote: >> Are there critical security or performance patches that should be >> applied to 824 and how could I have determined this without this post? > The changelog after 8.2.4 is below. I don't think there's a way to get > this easily, sho

[ADMIN] delayed actions

2007-07-10 Thread De Leeuw Guy
Hello all I write a new trigger in C. These trigger update a sums of rows and I have a strange problem : when I insert the data ok When I delete the data the DELETE are delayed and my trigger is fired a lot of time (see below) It is possible to flush the actions before exiting my trigger ? Thank

Re: [ADMIN] 8.2.4 patches?

2007-07-10 Thread Andrew Sullivan
On Tue, Jul 10, 2007 at 04:32:32PM -0400, Ray Stell wrote: > Are there critical security or performance patches that should be > applied to 824 and how could I have determined this without this post? If there were a real critical bug, there'd be a new release (which would mean 8.2.5). So the sho

Re: [ADMIN] 8.2.4 patches?

2007-07-10 Thread Alvaro Herrera
Ray Stell wrote: > Are there critical security or performance patches that should be > applied to 824 and how could I have determined this without this post? The changelog after 8.2.4 is below. I don't think there's a way to get this easily, short of having a copy of the CVS repository. 2007-0

Re: [ADMIN] 8.2.4 patches?

2007-07-10 Thread Richard Broersma Jr
--- Ray Stell <[EMAIL PROTECTED]> wrote: > Are there critical security or performance patches that should be > applied to 824 and how could I have determined this without this post? My understanding is that a security patch to Version 8.2.4 would be version 8.2.5, and so on. notice the followin

[ADMIN] 8.2.4 patches?

2007-07-10 Thread Ray Stell
Are there critical security or performance patches that should be applied to 824 and how could I have determined this without this post? Thanks. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to ch

Re: [ADMIN] vacuumdb problem v7.4.8

2007-07-10 Thread Tom Lane
Juliann Meyer <[EMAIL PROTECTED]> writes: >vacuumdb: vacuuming of database "adb_ob72orn" failed: ERROR: could not >read block 18658 of relation "pecrsep_time_ind": Input/output error This says read() failed with errno EIO, ie the operating system reported a hardware failure while trying t

[ADMIN] vacuumdb problem v7.4.8

2007-07-10 Thread Juliann Meyer
Have 14 systems scattered across the country where... hardware is identical, all run linux OS RHE4.0 with postgresql v7.4.8. The hardware is about 4 years old and is scheduled for replacement sometime next year. The database structure is identical on each system, the difference is in the data th

Re: [ADMIN] Performance benchmarking

2007-07-10 Thread Jayakumar_Mukundaraju
Dear Vishal, Thanks for the timely help... I installed jobs scheduler in my windows box.. Kindly guide me how to set the job schedule. Thanks & Regards Jayakumar M From: [EMAIL PROTECTED] on behalf of Vishal Arora Sent: Fri 7/6/2007 10:25 PM To: [EMAIL PRO

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Alvaro Herrera
Carmen Martinez escribió: > I'd like to use the same system we did with oracle due all the rdbms > use a catalog in order to store their system tables and structures. > Using the CREATE TYPE sentence implies a new implementation totally > different from the previous one. We may be able to help y

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Carmen Martinez
I'd like to use the same system we did with oracle due all the rdbms use a catalog in order to store their system tables and structures. Using the CREATE TYPE sentence implies a new implementation totally different from the previous one. Peter Childs <[EMAIL PROTECTED]> escribió: On 10/07/07

Re: [ADMIN] local kerberos authentication?

2007-07-10 Thread Stephen Frost
* Peter Koczan ([EMAIL PROTECTED]) wrote: > If I change the method to trust, it works, so it looks like krb5 isn't > supported for local connections, at least not on the surface. I'd also like > to get away from trust authentication because of the wonderful security > problems it entails. 'loca

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Peter Childs
On 10/07/07, Carmen Martinez <[EMAIL PROTECTED]> wrote: I know all you say, but we actually are trying to extend the postresql with new data types, and they must be theorically in the system catalog. Also, these new data types go with some functions for manage it. We have also implemented this

Re: [ADMIN] Catalog insertion

2007-07-10 Thread Carmen Martinez
I know all you say, but we actually are trying to extend the postresql with new data types, and they must be theorically in the system catalog. Also, these new data types go with some functions for manage it. We have also implemented this in Oracle and now we want to do this with postgresql.