[ADMIN] pg_dump problem

2006-08-06 Thread Srinivas Iyyer
Dear group, I have two databases in my system. In firstdb i am having the following problem: firstdb=# \d targets ERROR: could not access status of transaction 362 DETAIL: could not open file "/var/lib/pgsql/data/pg_clog/": No such file or directory when I vacuumed it: $ vacuu

Re: [ADMIN] running PostGres without installing it

2006-08-06 Thread Aaron Bono
On 8/5/06, jesus martinez <[EMAIL PROTECTED]> wrote: i want to distribute a copy of PostGres to my clients.they really dont know anything about installingprograms orconfigurating remote RDBMS sql-servers,so i dont want to give them the"official-PostGres-installer.exe "but my own installer.exe (win3

Re: [ADMIN] running PostGres without installing it

2006-08-06 Thread Chris Mair
> For years I have struggled with desktop applications and data > access/storage. Databases are very powerful tools but, other than MS > Access, I have not seen any that are easily distributable bundled with > a desktop application. Not having a personal database to bundle with > my applications

Re: [ADMIN] running PostGres without installing it

2006-08-06 Thread Amadeus Zilfinski
> > For years I have struggled with desktop applications and data > access/storage. Databases are very powerful tools but, other than MS > Access, I have not seen any that are easily distributable bundled with > a desktop application. Not having a personal database to bundle with > my applicati

Re: [ADMIN] running PostGres without installing it

2006-08-06 Thread Aaron Bono
On 8/6/06, Amadeus Zilfinski <[EMAIL PROTECTED]> wrote: >> For years I have struggled with desktop applications and data> access/storage.  Databases are very powerful tools but, other than MS> Access, I have not seen any that are easily distributable bundled with > a desktop application.  Not havin

[ADMIN] Disk usage in postgresql 8.1.4

2006-08-06 Thread Geoff Parker
Hi, I've got a database with about 155GB of binary data, however when I run the unix utility df, it reports only 60GB of disk space is being used.   I've extracted random samples of data from the database, and it all appears correct, so I presume it's not corrupt.   Can anyone tell me whether there

Re: [ADMIN] running PostGres without installing it

2006-08-06 Thread Amadeus Zilfinski
> > > Would something like SQLite support the full functionality that we get > from PostgreSQL: subqueries, transactions, views, triggers and stored > procedures? MySQL does not (yes I know they are adding some or all of > this but it isn't all there or proven to be reliable yet). > > I will

Re: [ADMIN] Disk usage in postgresql 8.1.4

2006-08-06 Thread Michael Fuhr
On Sun, Aug 06, 2006 at 04:42:47PM -0700, Geoff Parker wrote: > I've got a database with about 155GB of binary data, however > when I run the unix utility df, it reports only 60GB of disk space > is being used. I've extracted random samples of data from the > database, and it all appears correct

Re: [ADMIN] running PostGres without installing it

2006-08-06 Thread Christopher Browne
[EMAIL PROTECTED] (Amadeus Zilfinski) wrote: > My only real issue with PostgresQL is that it is a client/server > database, that is not embeddable. If it was embeddable then I could > use it with no issue, and would in fact rather use it. I recall some > people are working on that, but don't have a

[ADMIN] unsubscribe

2006-08-06 Thread Yoon Lee
unsubsribe me. -- Yoon Lee Software Developer W:604 451 4514 C:604 512 4460 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your messag

[ADMIN] unsubscribe

2006-08-06 Thread Remigio F. Taga
---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] unsubcribe

2006-08-06 Thread nhan nguyen
nhan Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail Beta.

[ADMIN] Minor problem with autovacuum

2006-08-06 Thread Benjamin Krajmalnik
I have a minor problem with autovacuum. Below are the logs: 2006-08-06 15:37:08 MDTLOG: autovacuum: processing database "postgres" 2006-08-06 15:37:22 MDTFATAL: database "psotgres" does not exist 2006-08-06 15:37:52 MDTFATAL: database "psotgres" does not exist 2006-08-06 15:38:22 MDTFATAL: dat

Re: [ADMIN] Minor problem with autovacuum

2006-08-06 Thread Benjamin Krajmalnik
Ignore question. I found the problem. When I launched pgagent, I had a transposition of the database name. After I identified thi and restarted pgagent everything looks ok. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Benjamin Krajmalnik