[ADMIN] Jobs not running

Hi, RHEL 5.2 x86_64 Postgres 8.3.5 pgAgent3 1.8.4 I noticed that at some point a job I have defined in the agent stopped running. I don't see any related errors in the logs at debug level. The script that the job is supposed to run runs at command line fine. Any ideas on how to troubleshoot this

[ADMIN] Postgres for BLOB ?

Hello, How does postgres perform with large object (pdf,word docs,images,mp3,mp4) storage ? For my system, individual object size will be at max a few MBs with most objects being less than a MB. Also between "TOAST" and "large objects" what is more preferred ?What are the other alternatives (fi

Re: [ADMIN] Problems whit role and privileges

=?iso-8859-1?Q?Eduardo_S=E1_dos_Reis?= writes: > I'm using postgresql 8.4 and have created several roles. > When I create a new database and then check the dependencies of schema public > my previously created roles appear as dependencies. > I did not understand why. Can anyone help me? I think

[ADMIN] Problems whit role and privileges

Hi, I'm using postgresql 8.4 and have created several roles. When I create a new database and then check the dependencies of schema public my previously created roles appear as dependencies. I did not understand why. Can anyone help me? Example Thanks a lot. Eduardo