[ADMIN] unsubscribe

2006-08-09 Thread Gourish Singbal
-- Best,Gourish Singbal

[ADMIN] Unsuscribe

2006-08-09 Thread Mohamed Fazil
Regards Mohamed Fazil Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta.

[ADMIN] unsubscribe

2006-08-09 Thread Mohan R
Please unsubscribe RegardsR MohanBlue Star Infotech LimitedT : +91-22-6695696

[ADMIN] Unsubscribe

2006-08-09 Thread Poku, Emmanuel
Title: [ADMIN] Unsubscribe Unsubscribe me please!

Re: [ADMIN] unsubscribe

2006-08-09 Thread Devrim GUNDUZ
Hello, On Wed, 2006-08-09 at 17:28 +0530, Mohan R wrote: Please unsubscribe Use http://www.postgresql.org/community/lists/subscribe and select unsubscribe from action box. You must do it by yourself. -HAND, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL

[ADMIN] teste

2006-08-09 Thread Andrea
Desculpa por este e-mail es solo para verificar que esta ocurriendo en mi caixa de mensagem por que no recibo mas nada desta lista. Gracías, Andréa ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [ADMIN] pg_hba.conf includes

2006-08-09 Thread Adam Fernie
Hi, I understand how the subnetting works. What I had problems with was putting more than one IP address / hostname into the include file. If my include file looks like so... file start 1.2.3.4 file end Then it works fine If the include file looks like this... file start 1.2.3.4 1.2.3.5 file

Re: [ADMIN] Start-up script for Solaris

2006-08-09 Thread mcelroy, tim
Title: RE: [ADMIN] Start-up script for Solaris Thanks Jim, good to hear from you again. Well for starters, if anyone out there does have a Solaris 9 or 10 startup script that they could post it would be appreciated. I will check on the Sun site as well, if I find anything I'll post it to

[ADMIN] service account

2006-08-09 Thread Thomas Vatter
I have tried creating the service account manually before starting the installer. Nevertheless the installer says "User account .d\ d does not exist". The batch file is msiexec /i postgresql-8.1-int.msi /qn INTERNALLAUNCH=1 DOSERVICE=1 DOINITDB=1 CREATESERVICEUSER=0

Re: [ADMIN] Strange UTF8 issue with pg_dump/pg_restore

2006-08-09 Thread Jim Nasby
Title: Re: [ADMIN] Strange UTF8 issue with pg_dump/pg_restore Please include the list in your replies so other people can help. -Original Message-From: Benjamin Krajmalnik [mailto:[EMAIL PROTECTED]Sent: Tuesday, August 08, 2006 10:31 PMTo: Jim NasbySubject: RE: [ADMIN] Strange

[ADMIN] vacuumdb exclude tables option?

2006-08-09 Thread Joel Stevenson
Hi, I have a database that includes both highly transactional tables and archive tables - OLTP and OLAP mixed together. Some of the archival tables, which only experience inserts and reads, not updates or deletes, contain many millions of rows and so they take a *long* time to vacuum. Is

Re: [ADMIN] vacuumdb exclude tables option?

2006-08-09 Thread Scott Marlowe
On Wed, 2006-08-09 at 13:24, Joel Stevenson wrote: Hi, I have a database that includes both highly transactional tables and archive tables - OLTP and OLAP mixed together. Some of the archival tables, which only experience inserts and reads, not updates or deletes, contain many millions

Re: [ADMIN] Performance tuning question

2006-08-09 Thread adey
A vacuum full analyze might help. On 8/8/06, Benjamin Krajmalnik [EMAIL PROTECTED] wrote: Chris,I just finished running some benchmarks on an underpowered servercompared to the one I am running in production. My initial tests were run on an ampty database, pg_xlog on the samespindle.Stored

Re: [ADMIN] How to know the sizes of all tables indexes in a database

2006-08-09 Thread adey
Try:- SELECT relname, relpages, CAST(reltuples AS numeric) ,( (relpages*8192)/1024 ) as MBFROM pg_class ...which will give you space used on disk for all data pages currently in use per table (assuming you have 8k data pages - the default). On 8/9/06, Sharma;G.S. [EMAIL PROTECTED] wrote: Hi,

Re: [ADMIN] How to specify alternative locations for

2006-08-09 Thread Bruce Momjian
I suggest you use symlinks to accomplish this. I don't think we have enough demand to make this configurable. --- Richard Chen wrote: Hi, The documentation says the locations for these files should be in

Re: [ADMIN] vacuumdb exclude tables option?

2006-08-09 Thread adey
Does autovacuum replace the need for a FULL vacuum please (to recover free space, etc)? On 8/10/06, Scott Marlowe [EMAIL PROTECTED] wrote: On Wed, 2006-08-09 at 13:24, Joel Stevenson wrote: Hi, I have a database that includes both highly transactional tables and archive tables - OLTP and OLAP

[ADMIN] Programmatically changing passwords

2006-08-09 Thread David Leangen
Hello! I am trying to build an RPM package that will put my Postgres installation into a known (usable) state, without requiring any interaction. To this effect, I need to do the following: 1. set password for superuser 2. createuser user 3. createdb -O user dbname No problems with (3)

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Tom Lane
David Leangen [EMAIL PROTECTED] writes: I am trying to build an RPM package that will put my Postgres installation into a known (usable) state, without requiring any interaction. To this effect, I need to do the following: 1. set password for superuser Basically, you can't. The entire

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Joshua D. Drake
David Leangen wrote: Hello! I am trying to build an RPM package that will put my Postgres installation into a known (usable) state, without requiring any interaction. To this effect, I need to do the following: 1. set password for superuser 2. createuser user 3. createdb -O user dbname

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread David Leangen
Thank you. Reply below. On Aug 10, 2006, at 13:54, Tom Lane wrote: David Leangen [EMAIL PROTECTED] writes: I am trying to build an RPM package that will put my Postgres installation into a known (usable) state, without requiring any interaction. To this effect, I need to do the following:

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread David Leangen
Thank you! Reply below. On Aug 10, 2006, at 13:59, Joshua D. Drake wrote: David Leangen wrote: Hello! I am trying to build an RPM package that will put my Postgres installation into a known (usable) state, without requiring any interaction. To this effect, I need to do the following: 1.

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Tom Lane
David Leangen [EMAIL PROTECTED] writes: Yes, that is my point. After having installed the standard postgresql package, I would then install my custom-postgres-config package. In this package, I tinker with the default configuration so I can put postgres into a known state

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Thomas Pundt
On Thursday 10 August 2006 07:12, David Leangen wrote: | ALTER USER foo with encrypted password 'bar'; | CREATE USER foo; | CREATE DATABASE bar owner foo; | | That makes perfect sense, but how can I do this from the shell? Is | there an easy way to wrap these so I can send them to postgres from