Hi All, (sorry for the .questions/.hackers crosspost) I'm a relatively new Linux / PostgreSQL user, and I've been scouring for a few weeks now to find an answer to my problem -- bugging newsgroups with my newbie questions is my last resort. I have a Postgres DB that I wish to have automagically pg_dumped to a dated text file and burned to a Multi-Session CD. These are two seperate issues (I can't get either to work properly) that I need help with -- the scripted database dump and then the sequential cd burn. Here is the command I tried using: pg_dump -C -d myDb > myDbSept.out The problem is that I need a login / password to execute this command, and it is asking for a password at an echo prompt! I tried using the PGUSER / PGPASSWORD variables, but they didn't work (or, at least I don't know how to use them properly) As for the cd-burning component, that's a whole other mess I'm going to have to bug the linux.cd people about. Could someone please nudge me in the right direction, or if they've already done something like this (with the burn), perhaps post up a sample of their script? Thanks ever so much, Rums. REMOVErumsAThomeDOTcom ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
