[GENERAL] computing and updating the size of a table with large objects

r, but uses just one file descriptor for all the query. Does anyone has any other suggestion? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [GENERAL] computing and updating the size of a table with large objects

- > Daniel > PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org > Thanks a lot for the suggestion: I didn't think to use the pg_largeobject: much cleaner, now :-) Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

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: [GENERAL] [ADMIN] backup of postgres scheduled with cron

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 9: In versions below 8.0, the planner will ignore your desire to

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

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: [GENERAL] Temporary Tables and Web Application

they have been written > to disk/read from disk? You could create a real table on disk, inserting just the primary keys of the table; then, you could join on the main table, to get the real results. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general m

[GENERAL] Advice on implementing counters in postgreSQL

one of them has to be restarted and redone from scratch. Is there a way to avoid this behaviour? maybe with lock to tables? Thanks you all for your attention Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T

Re: [GENERAL] Advice on implementing counters in postgreSQL

AM, Craig Ringer <[EMAIL PROTECTED]> wrote: > Marco Bizzarri wrote: >> Hi all. >> >> I need to keep a numer of counters in my application; my counters are >> currently stored in a table: >> >> name | next_value | year >> >> >> The counters mu

Re: [GENERAL] Advice on implementing counters in postgreSQL

On Sat, Aug 2, 2008 at 11:04 AM, Craig Ringer <[EMAIL PROTECTED]> wrote: > Marco Bizzarri wrote: >> Thanks for the advice, Craig. >> >> I'm on a number of different PostgreSQL versions, ranging from 7.4 to >> 8.3, so I've to retain, where possible, com

Re: [GENERAL] Advice on implementing counters in postgreSQL

On Sat, Aug 2, 2008 at 5:11 PM, David Fetter <[EMAIL PROTECTED]> wrote: > On Sat, Aug 02, 2008 at 09:23:31AM +0200, Marco Bizzarri wrote: >> Hi all. >> >> I need to keep a numer of counters in my application; my counters >> are currently stored in a table: >>

Re: [GENERAL] Advice on implementing counters in postgreSQL

y code. Up to now, I wrote considering a serializable level, so I think I should do quite a review to be sure about it. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql RPM upgrade (8.2.3 -> 8.2.9)

ssed. If that does not solve the problem, post the error message. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] warning: libssl.so.4, needed by

On Fri, Aug 29, 2008 at 2:39 PM, J Welcomecert <[EMAIL PROTECTED]> wrote: It looks like you haven't openssl installed on your system, or you didn't provided the right switches for compiling it? Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ http://iliveinp

[GENERAL] Questions about the use of largeobject functions from inside SQL

Hi all. We have a setup with Zope and a remote Postgresql server. We're storing blobs in largeobject files. What we need to do is to be able to do the transfer of blobs between Zope and postgres. I thought it was possible to use lo_* functions, by creating a largeobject, and then sending the da

Re: [GENERAL] Storing images in PostgreSQL databases (again)

. I think there are differences also in how the space is reclaimed, but my PostgreSQL - Fu stops here. Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] basic SQL request

You wrote articletype instead of articletypes in the first WHERE clause: is this the problem? Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/ ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [GENERAL] permission in the db or in the application?

application. If you have time (and money) take a look at Chapter 20 from "Agile Database Techniques" from Scott Ambler: it examines a number of possibilities which could be worthy to you. Regards Marco -- Marco Bizzarri http://iliveinpisa.blogspot.com/

[GENERAL] Certifications in military environment

Hi all. I would like to know if postgresql has any certification for the military environment. If possible, please answer me directly (I'm not on this mailing list). Otherwise, I will read from the web interface. Regards Marco ---(end of broadcast)---

Re: [GENERAL] Certifications in military environment

Jeff Eckermann wrote: --- Marco Bizzarri <[EMAIL PROTECTED]> wrote: Hi all. I would like to know if postgresql has any certification for the military environment. There are no official certifications, nor are there likely to be. But certifications may be offered by individual companies

Re: [GENERAL] MySQL insert() and instr() equiv

----- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send a

[GENERAL] Changing encoding of a database

I all. We've PostgreSQL database, with SQL_ASCII or LATIN1 encoding. We would like to migrate them to UNICODE. Is there some contributed/available script, or this is something we should do at hand? Regards Marco -- Marco Bizzarri http://notenotturne.blogspo

Re: [GENERAL] Changing encoding of a database

Hi Tomi. Thanks for your answer, I was not aware of such a tool. The next question at this point is (of course): what is the problem if I have blob? Should I recode them as well? Regards Marco On 6/20/06, Tomi NA <[EMAIL PROTECTED]> wrote: On 6/19/06, Marco Bizzarri <[EMAIL PROTECTE

[GENERAL] Documentation of the Front End/Back End Protocol for Large Objects

ed in client (libpq, I suppose)? Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Documentation of the Front End/Back End Protocol for Large Objects

Hi Tom. Thanks for your suggestion, this was my choice, after I was unable to find any reference. On 6/23/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Marco Bizzarri" <[EMAIL PROTECTED]> writes: > I would like to study the protocol for large object operations > (lo

[GENERAL] Dumping in LATIN1 and restoring in UTF-8

gh it worked for us, I wonder if there is any other way to accomplish the same result, at least to specify the encoding for the restore. Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 9: In versions belo

Re: [GENERAL] Dumping in LATIN1 and restoring in UTF-8

On 7/6/06, Tino Wildenhain <[EMAIL PROTECTED]> wrote: Marco Bizzarri schrieb: > Hi all. > > Here is my use case: I've an application which uses PostgreSQL as > backend. Up to now, the database was encoded in SQL_ASCII or LATIN1. > Now, we need to migrate to UTF-8.

Re: [GENERAL] Dumping in LATIN1 and restoring in UTF-8

enccoding setting in the backup is only needed in the case when you had data in the wrong encoding - like SQLAscii filled with latin-1 or something) Ok, thanks! Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Fwd: [GENERAL] Long term database archival

-- Forwarded message -- From: Marco Bizzarri <[EMAIL PROTECTED]> Date: Jul 12, 2006 9:03 PM Subject: Re: [GENERAL] Long term database archival To: "Karl O. Pinc" <[EMAIL PROTECTED]> Long term archival of electronic data is a BIG problem in the archivist co

[GENERAL] Clustering and backup with large objects

ing performance, rather than availability. Thanks for your attention. Regards Marco -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] logic/db question

he children (and children's children...) of a top level item? i had done this awhile ago.. but can't recall how i did it.. thanks ---(end of broadcast)--- TIP 6: explain analyze is your friend -- Marco Bizzarri http://notenotturne.blo

Re: [GENERAL] Consulta

mensaje ha sido analizado por MailScanner en busca de virus y otros contenidos peligrosos, y se considera que está limpio. MailScanner agradece a transtec Computers por su apoyo. -- Marco Bizzarri http://notenotturne.blogspot.com/ ---(end of broadcast)-

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

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] Database migration and redesign

e reader is hereby notified that any dissemination, distribution or copying of this email is prohibited. If you have received this email in error, please notify the sender by replying to this message and deleting this email immediately. -- Marco Bizzarri http://notenotturne.blogspot.com/

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

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

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

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