Re: [ADMIN] execute batch

2005-12-23 Thread Qingqing Zhou
""uva raj"" <[EMAIL PROTECTED]> wrote > i want to execute a batch with 1000 statements. > is there any limit for number of statements or size. > please reveal. If you mean how many statements in a transaction is supportted, then the de-facto limit depends on your statement resource consumption.

Re: [ADMIN] Need Suggestion about new version of PostgresSQL 8.1

2005-12-23 Thread Qingqing Zhou
"Mohamed Fazil" <[EMAIL PROTECTED]> wrote > > I am planning to impliment the new release of Postgres SQL 8.1 in my > application. Before implimenting i would like to know if Postgres SQL 8.1 > is stable enough or should Postgres SQL 8.0 be choosen. > Well, there are proofs that both versions a

Re: [ADMIN] lo_ functions

2005-12-23 Thread Alain Rodriguez Arias
I have a field in a table that I use to save data from a PDF file and I need to save the file in a given address   On 12/22/05, sandhya <[EMAIL PROTECTED]> wrote: You can very well get from the following link. http://www.postgresql.org/docs/8.1/interactive/largeobjects.html - Original Messa

Re: [ADMIN] WAL and pg_dump

2005-12-23 Thread Stephen Frost
* Simon Riggs ([EMAIL PROTECTED]) wrote: > On Fri, 2005-12-23 at 08:43 -0500, Stephen Frost wrote: > > Of course, I can also do snapshots with the SAN, but that's a > > one-time thing unlike PITR where you can choose any point in time to > > recover to. > > Why not use SAN Snapshots *and* PITR? Th

Re: [ADMIN] WAL and pg_dump

2005-12-23 Thread Simon Riggs
On Fri, 2005-12-23 at 08:43 -0500, Stephen Frost wrote: > * Tom Lane ([EMAIL PROTECTED]) wrote: > > Stephen Frost <[EMAIL PROTECTED]> writes: > > > As I recall, the initial backup of our 360GB (or so) database took > > > about 6 hours and the restore only took about 2 hours. > > > > Really? I'd c

Re: [ADMIN] WITH SYSID feature dropped

2005-12-23 Thread Stephen Frost
* Donald Fraser ([EMAIL PROTECTED]) wrote: > > On Wed, Dec 21, 2005 at 04:35:00PM -, Donald Fraser wrote: > > > Our module controls things like: > > > 1) how long before a user must change their password (daily, weekly, > > > monthly etc) > > > 2) password rotation - for example a user cannot u

Re: [ADMIN] WAL and pg_dump

2005-12-23 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > As I recall, the initial backup of our 360GB (or so) database took > > about 6 hours and the restore only took about 2 hours. > > Really? I'd certainly have guessed the opposite (mainly because of > index build

Re: [ADMIN] WITH SYSID feature dropped

2005-12-23 Thread Donald Fraser
> On Wed, Dec 21, 2005 at 04:35:00PM -, Donald Fraser wrote: > > Roles are a great improvement to postgresql, but we also talking security > > issues here: > > Our module controls things like: > > 1) how long before a user must change their password (daily, weekly, monthly > > etc) > > 2) pass

[ADMIN] Need Suggestion about new version of PostgresSQL 8.1

2005-12-23 Thread Mohamed Fazil
Hi ,   I am planning to impliment the new release of Postgres SQL 8.1 in my application. Before implimenting i would like to know if Postgres SQL 8.1 is stable enough or should Postgres SQL 8.0 be choosen.   Mohamed Fazil Yahoo! Photos Ring in the New Year with Photo Calendars. Add photos, e

Re: [ADMIN] WAL and pg_dump

2005-12-23 Thread Simon Riggs
On Fri, 2005-12-23 at 14:34 +1300, Mike C wrote: > Is space your limiting factor? > > Yes, space is our limiting factor. A pg_dump archive format backup > takes about 40mins for 25GB. A restore IIRC takes about 2 hours. > However the size of the database is expected to grow to about 120 G