-- Best,Gourish Singbal
Regards Mohamed Fazil
Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta.
Please unsubscribe
RegardsR MohanBlue Star Infotech
LimitedT : +91-22-6695696
Title: [ADMIN] Unsubscribe
Unsubscribe me please!
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
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?
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
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
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
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
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
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
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
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,
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
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
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)
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
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
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:
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.
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
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
23 matches
Mail list logo