Re: [ADMIN] rename

Title: This should be what you need… http://www.postgresql.org/docs/current/interactive/sql-alterdatabase.html         Thank you! Troy Campano Liberty Mutual   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Beha

[ADMIN] Databases on separate filesystems

I need to have each one of my PostgreSQL databases put on a separate filesystem. I wanted to do the following…can someone verify that this will work?     1)   Create the following environment variables: a. export PGDATA01=/filesystem1 b. export PGDATA02=/filesystem2 c. export PGDATA

[ADMIN] Postgresql Bulk Loading

Does Postgresql have a bulk loading utility that allows you to load large amounts of data and doesn’t write to log files (WAL files) ? I need to load over a gig of data a day and don’t want it to write to logs.     Thank you!   ~ Troy Campano ~

[ADMIN] Database Size Limiting

Title: Database Size Limiting Is there a way to limit the size that an individual database can take up? My understanding is that all your databases go into a file system which is your ‘catalog cluster’. But all the databases can grow until that filesystem is full. Is there a way to limit h

[ADMIN] FW: [GENERAL] shell script when a user logs in

Title: Message I posted this in GENERAL, but figured maybe this might be better place.   -Original Message-From: Campano, Troy [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 1:56 PMTo: [EMAIL PROTECTED]Subject: [GENERAL] shell script when a user logs in Is there a shell

[ADMIN] Viewing connections

Is there an easy way to see what connections are open in a PostgreSQL server? Any way to see if they are active? thank you! ~ Troy Campano ~ ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge

Re: [ADMIN] dbsize

Would you want to talk to this person: [EMAIL PROTECTED] from this page: http://webmail.postgresql.org/~petere/index.html I'd be interested in finding out why you get this error though. thank you. ~ Troy Campano ~ -Original Message- From: Andreas Schmitz [mailto:[EMAIL PROTECTED]] Se

[ADMIN] Incremental backups?

Is there a way to do incremental backups or backups of the changes in PostgreSQL? It seems that if I do complete database backups with pg_dump that I'll be getting a lot of redundancy. What are your thoughts? thank you! ~ Troy Campano ~ ---(end of broadcast)---