Re: [ADMIN] fsync off without a restart

2008-08-28 Thread Marco Bizzarri
differ from the plain reload? And what does it > actually do under the hood? If you're referencing to the init script (/etc/init.d/postgresql-XXX), then they should be the same stuff. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-admin mailing li

Re: [ADMIN] [GENERAL] Dumping/Restoring with constraints?

2008-08-27 Thread Marco Bizzarri
r any > advice. > > -- > Sent via pgsql-general mailing list ([EMAIL PROTECTED]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Isn't the --disable-triggers working for you? -- Marco Bizzarri http://iliveinpisa.blogspot.co

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Marco Bizzarri
On Nov 22, 2007 2:53 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote: > > > > why don't you add a "MAILTO=" at the start of your > > crontab file, so that you can receive a report of the probl

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Marco Bizzarri
ms strange > > Try putting the full path of the pg_dump command in the script. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Marco Bizzarri
backups manually. The script > itself is executed fine if run manually but run on cron scheduler I got an > mydb_dump_$time.out file empty (of 0 kb) > > Do you have any idea about what's wrong? > > Thanks > Sorin > Hi Sorin, why don't you add a &q

Re: [ADMIN] Fastest DB restore options

2007-02-22 Thread Marco Bizzarri
out, you can always throw all away and start from scratch... Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Marco Bizzarri
On 9/11/06, Purusothaman A <[EMAIL PROTECTED]> wrote: Hi Marco Bizzarri and Martijn van Oosterhout, Thanks for your valuable reply. I am trying to execute all query from VC++ through CDatabase::ExecuteSQL(sQueryString) function call. ie, via programming, not by manual entering

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Marco Bizzarri
0); lo_close -- 0 (1 row) (you closed the file). commit ; COMMIT In this way, you created a new large object, and stored a string of 4 bytes inside of it. Regards Marco On 9/11/06, Purusothaman A <[EMAIL PROTECTED]> wrote: Thanks Martijn van Oosterhout and Marco Bizzarri. But, acc

Re: [GENERAL] [ADMIN] Problem with lo_export() and lo_import() from remote machine.

2006-09-11 Thread Marco Bizzarri
> > >iD8DBQFFAq41IB7bNG8LQkwRAsptAKCDSWuRI5T+JMqpWEQt7r69kJE6CwCfVTOO > >mOqGDNQBTZZDs4WVf6NM+wQ= > >=kT4s > >-END PGP SIGNATURE- > > > > > > -- Martijn van Oosterhout http://svana.org/kleptog/ > From each according to his ability. To

[ADMIN] Checking what is the current query running

2006-07-25 Thread Marco Bizzarri
Hi all. I've a postgresql where sometimes a process can remaing running a query for a very long time. Aside from logging the queries, is there a way to know which query is running in one particular moment? Regards Marco -- Marco Bizzarri http://notenotturne.blogspo

Re: [ADMIN] reg:lo_write

2006-06-22 Thread Marco Bizzarri
Did you look at this example? http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/prog/largeobjects.html (I think you can find better example in the postgresql documentation, this was the first one I found) On 6/22/06, Marco Bizzarri <[EMAIL PROTECTED]> wrote: Hi Sandhya. O

Re: [ADMIN] reg:lo_write

2006-06-22 Thread Marco Bizzarri
how can i over come this problem?So that i can proceed further - Original Message - From: "Marco Bizzarri" <[EMAIL PROTECTED]> To: "sandhya" <[EMAIL PROTECTED]> Cc: "Postgres" Sent: Thursday, June 22, 2006 1:43 PM Subject: Re: [ADMIN] reg:

Re: [ADMIN] reg:lo_write

2006-06-22 Thread Marco Bizzarri
dataIt will append to the previous content right!Am i wrong? If i wants to append the content to the present object is there anything i need to do? Please help me in doing this I am unable to see the image which i am exporting... Thank you, Sandhya -- Mar