[GENERAL] show connection limit?
I have set the connection limit of a user with the ALTER ROLE command in 8.1. Is there a way to see what the connection limit is set to for various users? Thanks, Ken
Re: [GENERAL] Data Warehousing
>I am on a Linux platform but I'm going to need some pointers regarding >the cron job. Are you suggesting that I parse the dump file? I assume I >would need to switch to using inserts and then parse the dump looking >for where I need to start from? Something that you may want to consider is dblink from contrib. We have a similar situation for the archiving of collected data and have been able to implement a fairly easy solution that does not require the parsing of dump files, just a simple(ish) query based on the time inserted. -Ken ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] good sql tutorial
Scott Marlowe wrote: > On 10/4/07, Geoffrey <[EMAIL PROTECTED]> wrote: >> Anyone have a recommendation for a good sql tutorial? Looking for a >> book, but online would be useful as well. > > I'd recommend The Art of SQL and Joel Celko's books. None are online > that I know of, but they're affordable and quite informative. I have found this to be an excellent book: O'Reilly Learning SQL http://www.amazon.com/Learning-SQL-Alan Beaulieu/dp/0596007272/ref=pd_bbs_1/103-3121914-1316662?ie=UTF8&s=books&qid= 1191519417&sr=8-1 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
