I've been using Gmail and thought you might like to try it out. Here's an
invitation to create an account.
You're Invited to Gmail!
K P Manoj has invited you to open a Gmail account.
Gmail is Google's free email service, built on the idea that email can be
intuitive, efficient, and fun. Gmail
Sathish Reddy Yelala wrote:
> Thanks for the response.Here I have few more queries regarding
> Connections.
>
> 1.When the connection goes to state
When the server has completed a request and waits for
the next one.
> 2. when the connection becomes active
When the server receives the n
hi,
Thanks for the response.Here I have few more queries regarding
Connections.
1.When the connection goes to state
2. when the connection becomes active
3.Is there any chance to database get slow because of connections
Any help would be appreciated..
Em 28-01-2013 07:12, Sathish Reddy Yelala escreveu:
Hi,
we had problem with connections.when we start the database
there huge number of connections goes to which leads to database
access slow.
These connections are opened by your client application, not by PostgreSQL.
How can we
Hi,
we had problem with connections.when we start the database there
huge number of connections goes to which leads to database access
slow.
How can we prevent the connections and also where we can see the
connection query so that we can identify.
On Thu, Aug 30, 2012 at 3:33 AM, Albe Laurenz wrote:
> Gary Webster wrote:
> > The subject says most of what I know at this point.
> >
> > We are still not getting along with Apache Jackrabbit.
> > After a few hours of using Postgres as the Persistence Manager, the
> JCR gets stuck, apparently on
On Wed, Aug 29, 2012 at 10:17 PM, Craig Ringer wrote:
> On 08/30/2012 03:37 AM, Gary Webster wrote:
>
>> Hello.
>> The subject says most of what I know at this point.
>>
>> We are still not getting along with Apache Jackrabbit.
>> After a few hours of using Postgres as the Persistence Manager, the
Hello.
The subject says most of what I know at this point.
We are still not getting along with Apache Jackrabbit.
After a few hours of using Postgres as the Persistence Manager, the JCR
gets stuck, apparently on a simple DB update statement.
This problem does not occur at all if we substitute MyS
Gary Webster writes:
> How bad is this?
> 2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 ERROR: missing
> chunk number 0 for toast value 1086399 in pg_toast_987417
> 2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 STATEMENT: VACUUM
> (FULL);
If it's repeatable, it's corrupted
Hello.
How bad is this?
2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 ERROR: missing
chunk number 0 for toast value 1086399 in pg_toast_987417
2012-08-01 06:30:03 PDT 15961 [local] cp_repository_na2 STATEMENT: VACUUM
(FULL);
Does this mean I have db corruption, or just that the vac
> -- Forwarded message --
>> So, you have everything running and working in aprox. 10 seconds.
>
> All of the Windows Server stuff via Microsoft Cluster Services I'm aware of
> does its shared storage node fencing via sending specific SCSI calls
> (PERSISTENT RESERVE) to the >stor
Hi
A hint : do you have any long running SQL requests, while there is some
network-control devices like firewalls between the client and the server ?
Using Oracle, we faced the same situation where a firewall in the middle broke
the connection after a period of network inactivity between the cl
Parece que estás con suerte: la versión 1.0 de odbc-link para Postgresql
acaba de ser lanzada.
http://www.cybertec.at/en/postgresql_downloads
Es un conector de Postgres hacía otras bases a través de odbc y en tu caso
amerita lo pruebes.
Interesante.
No tengo muy claro como se instalaría una l
Parece que estás con suerte: la versión 1.0 de odbc-link para Postgresql
acaba de ser lanzada.
http://www.cybertec.at/en/postgresql_downloads
Es un conector de Postgres hacía otras bases a través de odbc y en tu
caso
amerita lo pruebes.
Interesante.
No tengo muy claro como se instalaría un
> -Mensaje original-
> De: Luis Dominguez
>
>
> Buenos dias, gente del software libre una vez mas necesito
> de sus buenos conocimento para poder resolver un problema que
> tengo presente y que a continuacion les comento, estamos en
> un proceso de migracion de ms Slqserver/Window
Στις Thursday 22 April 2010 19:02:00 ο/η Cédric Villemain έγραψε:
> 2010/4/22 Achilleas Mantzios :
> > Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε:
> >> 2010/4/22 Achilleas Mantzios :
> >> > Hello,
> >> > i have this serious problem in one of our remote vessels. (comm is done
Si quieres hacer eso que dices desde Postgres simplemente no se puede. Puedes
mirar un poco con DBI-LINK no se que tanto estara avanzado o si no ha sido
abandonado, pero poder ligar en un mismo select tablas de ambos motores no
podras hacerlo, Postgres no soporta eso, pero con DBI-Link no se si
Estimado,
Te recomiendo algo mucho mas sencillo y eficaz para tu gestion de migracion.
Kettle de pentaho.
Con este ETL , podras transportar datos e informacion de donde sea, para
donde sea.
Un saludo,
German Salinas.
El 22 de abril de 2010 10:15, Luis Dominguez escribió:
>
>
> Buenos di
2010/4/22 Achilleas Mantzios :
> Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε:
>> 2010/4/22 Achilleas Mantzios :
>> > Hello,
>> > i have this serious problem in one of our remote vessels. (comm is done by
>> > minicom to the remote satelite modem)
>> > I think that this server
Στις Thursday 22 April 2010 17:42:33 γράψατε:
> Achilleas Mantzios writes:
> > Then i did: (as i said i do not need the contents of msgsource - yet the
> > contents of msgno are vital)
> > dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013
> > seek=672720 bs=8192 count=1
Στις Thursday 22 April 2010 16:53:05 ο/η Cédric Villemain έγραψε:
> 2010/4/22 Achilleas Mantzios :
> > Hello,
> > i have this serious problem in one of our remote vessels. (comm is done by
> > minicom to the remote satelite modem)
> > I think that this server was under some sort of constant resets
Achilleas Mantzios writes:
> Then i did: (as i said i do not need the contents of msgsource - yet the
> contents of msgno are vital)
> dd if=/dev/zero of=/usr/local/var/lib/pgsql/data/base/125714957/125716013
> seek=672720 bs=8192 count=1
> However, after that, unfortunately i get constant pos
2010/4/22 Achilleas Mantzios :
> Hello,
> i have this serious problem in one of our remote vessels. (comm is done by
> minicom to the remote satelite modem)
> I think that this server was under some sort of constant resets or hardware
> failures.
> Initially,i had this problem:
> ERROR: invalid
Hello,
i have this serious problem in one of our remote vessels. (comm is done by
minicom to the remote satelite modem)
I think that this server was under some sort of constant resets or hardware
failures.
Initially,i had this problem:
ERROR: invalid page header in block 672720 of relation "pg_t
Chander Ganesan
Sent: Tuesday, March 16, 2010 1:39 PM
To: Rangi, Jai
Cc: [email protected]
Subject: Re: [ADMIN] Pgsql Training.
Rangi, Jai wrote:
>
> All,
>
> Just signed up on the list. We are in the process of adopting pgsql
> over mysql. I was wondering if someone
Rangi, Jai wrote:
All,
Just signed up on the list. We are in the process of adopting pgsql
over mysql. I was wondering if someone can suggest any reasonably
priced training for pgsql Administration and development. We are in
southern CA. So anything closer to LA will be convenient and prefer
On Tue, 2010-03-16 at 10:35 -0700, Rangi, Jai wrote:
> All,
>
> Just signed up on the list. We are in the process of adopting pgsql
> over mysql. I was wondering if someone can suggest any reasonably
> priced training for pgsql Administration and development. We are in
> southern CA. So anything c
All,
Just signed up on the list. We are in the process of adopting pgsql over
mysql. I was wondering if someone can suggest any reasonably priced
training for pgsql Administration and development. We are in southern
CA. So anything closer to LA will be convenient and preferred.
There is lots of
Scott Marlowe writes:
> On Tue, Jun 9, 2009 at 11:57 PM, Hapase,
> Pranjali wrote:
>> But I am not able to connect to the PostgreSQL which is install on the
>> another machine.
> You need to edit two files to access pgsql remotely. postgresql.conf
> (listen_address) and pg_hba.conf (self documen
On Tue, Jun 9, 2009 at 11:57 PM, Hapase,
Pranjali wrote:
> Hello,
>
>
>
> I am using iReport tool for creating JasperReport & I use backend as
> PostgreSQL.
>
> But I am not able to connect to the PostgreSQL which is install on the
> another machine.
>
> Try to give me a solution.
You might want a
Imagino que si lo que descargaste es el .RPM sería algo como esto: rpm -i
pgadmin3-1.8.2.rpm.
Salu2
Ing. Reynier Pérez Mira
Grupo Soporte al Desarrollo - Dirección Técnica IP
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Sonia Perez Peña
Enviado
2008/4/2, Sonia Perez Peña <[EMAIL PROTECTED]>:
>
>
>
>
> Amigos ya baje el pgadmin3-1.8.2 gracias a un colega de la lista ¿Cómo lo
> debo instalar en FEDORA
podrias investigar en como usar el comando de yum para fedora,
seguramente ahi vendra el pgadmin.
--
"Linux is for people who hate Windo
On Wed, Feb 27, 2008 at 2:10 AM, Suresh Gupta VG <[EMAIL PROTECTED]> wrote:
> Hi team,
>
> Actually, the installation of the PGSQL is done by root user only. Can
> it be done with a normal user login? Does the user require any extra
> permission from server side or DB side?
It depends. If you
2008/2/27, Suresh Gupta VG <[EMAIL PROTECTED]>:
> Hi team,
>
> Actually, the installation of the PGSQL is done by root user only. Can
> it be done with a normal user login? Does the user require any extra
> permission from server side or DB side?
Yes, an unprivileged user can install and run Po
Hi team,
Actually, the installation of the PGSQL is done by root user only. Can
it be done with a normal user login? Does the user require any extra
permission from server side or DB side?
Regards,
G. V. Suresh Gupta
---
On Jan 17, 2008 11:43 AM, Jerome Blomart <[EMAIL PROTECTED]> wrote:
>
> I am working for a small company offering IT services.
> We are in the acceptance stage for a migration of an old UNIX app
> managing a huge load of data.
>
> This acceptance environment is using a VMWARE ESX platform, a j
> How-to monitor pgsql ?
> ( considering the server's general statistics and events are already
> covered :
> cpu usage, memory usage, shutdown and reboot events, unplanned down
> time )
> - i have got a net-snmp at service
> - i have got an event listener too ( traplistener + event-rules)
htt
Hello,
I really should ask if i am mailing to the correct mailing list in
regarding the question i will ask.
But ...
I am working for a small company offering IT services.
We are in the acceptance stage for a migration of an old UNIX app
managing a huge load of data.
This acceptan
The most important point is that third one, I think:
"any application where reliability requirements do not warrant
spending $1M to make it more reliable"
Adopting ORAC and/or other HA technologies makes it necessary to spend
a Big Pile Of Money, on hardware and the humans to administer it.
[EMAIL PROTECTED] (Achilleas Mantzios) writes:
>> I don't want to add gas to the flamewar, but I gotta ask. What is in
>> the the 90 to 95% referred to in this email.
>
> short answer: all cases, possibly except when running a Bank or something
> similar.
No, it's not to do with what enterprise
[EMAIL PROTECTED] (Carol Walter) writes:
> I don't want to add gas to the flamewar, but I gotta ask. What is in
> the the 90 to 95% referred to in this email.
I'd say, look at the Oracle feature set for things that it has that
PostgreSQL doesn't.
Four that come to mind:
- ORAC = multimaster rep
Hello,
I am using Windows 2000 Professional and I am trying to install Postgresql
8.2.3. I have created a restricted user under Windows called Postgres8.2.3.
When I try to use the Postgresql Installation Wizard, at the Service
Configuration step, when I have to enter info like Account name, dom
Daniel Medina wrote:
> Estaba tratando de crear una replica del servido y copiar los archivos
> de postgres para corregir el error...
>
> ahora en la maquina de prueba genere un dump de pg_shadow con lo mismos
> datos del de produccion, si entro como usuario standalone
> sobre la maquina de pro
Estaba tratando de crear una replica del servido y copiar los archivos
de postgres para corregir el error...
ahora en la maquina de prueba genere un dump de pg_shadow con lo mismos
datos del de produccion, si entro como usuario standalone
sobre la maquina de produccion borro la tabla pg_shadow
Daniel Medina wrote:
> Tengo instalado postgres en otra maquina exactamente igual a la de
> produccion , cree los mismos usuarios y base, pero si data,,
> alguien sabe cual es el archivo interno de postgres donde esta la tabla
> pg_shadow para copiarla al postgres que tiene la tabla corrupta...
Tengo instalado postgres en otra maquina exactamente igual a la de
produccion , cree los mismos usuarios y base, pero si data,,
alguien sabe cual es el archivo interno de postgres donde esta la tabla
pg_shadow para copiarla al postgres que tiene la tabla corrupta
he copiado la carpeta glo
Si señor, tiene toda la razon, el problema esta en las tablas de la
base, asi que me da lo mismo.
gracias..
Alvaro Herrera wrote:
Daniel Medina wrote:
Pregunta
tengo instalado postgres en el la carpeta /usr/local/pgsql/ , tengo
errores en las tablas de postgres y no me dej
Daniel Medina wrote:
> Pregunta
> >
> > tengo instalado postgres en el la carpeta /usr/local/pgsql/ , tengo
> > errores en las tablas de postgres y no me deja hacer backup, he
> > intentado modificar las tablas por medio de una conexion stand alone y
> > nada...
> >
> > puedo instalar postgres en
Pregunta
>
> tengo instalado postgres en el la carpeta /usr/local/pgsql/ , tengo
> errores en las tablas de postgres y no me deja hacer backup, he
> intentado modificar las tablas por medio de una conexion stand alone y
> nada...
>
> puedo instalar postgres en otra carpeta , por ejempo /opt/postg
oops...
I fat fingered that one...>
> I hope your other DBA wasn't canned for being a stanch Postgresql supporter.
> :o)
^^^
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
If you do a pgdump -s will dump out schema only from the Postgres database.
Much of this will be usable in SQL server to at least create your basic
database and objects. You will then need to interpret the remianing more
complex structures and build them / adapt the DDL, to work in SQL Server.
If
> Hi folks, new to this mailing group and here are my first questions.
>
> We've been running a PGSQL database for a while now on a Weenblows 2K
> server, on version 8.0.something.
>
> Our resident DBA has been shown the door and has taken with himself the
> admin password to get into the databas
Hi folks, new to this mailing group and here are my first questions.
We've been running a PGSQL database for a while now on a Weenblows 2K
server, on version 8.0.something.
Our resident DBA has been shown the door and has taken with himself the
admin password to get into the databases we run in P
Hi Group!
I am trying to work & connect php wirh PGSQL on Red Hat ES 3.
I got some Important path like:
/usr/share/pgsql/contrib
/usr/include/pgsql
/usr/bin
But I don't know how to start/stop pgsql server, Insert data from
client pgsql , view database files, admin database & configuration
f
Title: PGSQL Database Recovery in Portland Oregon Area needed ASAP
I have a client that is running an older version of Lyris List Manager against PostGres 7.1.2, that has crashed their database beyond my ability to recover it. The error that I am getting when we try and restart the database i
On Tuesday 14 March 2006 16:00, Kevin Grittner wrote:
> >>> On Tue, Mar 14, 2006 at 2:08 am, in message
>
> <[EMAIL PROTECTED]>, Simon Riggs
>
> <[EMAIL PROTECTED]> wrote:
> > On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote:
> >> Even more important is the fast response we have had when
>>> On Tue, Mar 14, 2006 at 2:08 am, in message
<[EMAIL PROTECTED]>, Simon Riggs
<[EMAIL PROTECTED]> wrote:
> On Mon, 2006- 03- 13 at 13:27 - 0600, Kevin Grittner wrote:
>> Even more important is the fast response we have had when posting
>> problems to the lists. We have normally had a fix with
On Mon, 2006-03-13 at 13:27 -0600, Kevin Grittner wrote:
> Even more important is the fast response we have had when posting
> problems to the lists. We have normally had a fix within 24 hours.
> Frankly, the support has been amazing.
Kevin, well done. We've all watched your progress with intere
>
>
> This seems insecure.
>
> How do I create a postgreSQL user account such that attempts to connect
> to it require authentication?
>
http://www.postgresql.org/docs/8.1/interactive/client-authentication.html
>
> -Dan
>
> ---(end of broadcast)--
On Sun, 22 Jan 2006, Dan Bikle wrote:
> I'm allowed to connect to the db10 database without authentication!:
>
> bash-2.05b$ psql db10 scott
> Welcome to psql 8.1.1, the PostgreSQL interactive terminal.
>
> Type: ＼copyright for distribution terms
>＼h for help with SQL commands
>＼
People,
I just installed postgreSQL 8.1.1 on my free-bsd box:
Creation of a database is easy:
bash-2.05b$ id
uid=70(pgsql) gid=70(pgsql) groups=70(pgsql)
bash-2.05b$ createdb -O pgsql db10
CREATE DATABASE
bash-2.05b$
I took a peek at help:
bash-2.05b$ psql --help
This is psql 8.1.1, the Postg
Hi,
what does "iptables -L" and "/var/log/postgresql" say? Is there a packetfilter? The socket sems to be ok.
Can you telnet to the the socket?
Regards,
Martin
Am Mittwoch, den 21.09.2005, 16:08 +0800 schrieb Nirav Parikh:
Hi Martin,
Thanks for prompt reply. As I said before
Hi
Martin,
Thanks for prompt reply. As
I said before I can connect through different server but can't connect locally.
This is the result
of netstat -anp | grep
postmaster
tcp
0 0
0.0.0.0:5432
0.0.0.0:*
LISTEN
2094/postmastertcp
On 7/26/05, Carolina Aldaco <[EMAIL PROTECTED]> wrote:
> A ver si alguien me puede ayudar aqui, en esta lista, Gracias, abajo esta mi
> duda sobre almacenamiento de datos grandes. Gracias
>
Lo dudo mucho porque esta es una lista en ingles... y quienes hablamos
español solo lo haremos para informa
A ver si alguien me puede ayudar aqui, en esta lista, Gracias, abajo esta mi duda sobre almacenamiento de datos grandes. GraciasAlvaro Herrera <[EMAIL PROTECTED]> escribió:
On Tue, Jul 26, 2005 at 10:18:56AM -0500, Carolina Aldaco wrote:> Como le digo, no me manda ningun mensaje de error, simplemen
On Thu, Jul 21, 2005 at 10:46:25AM -0400, Brad Nicholson wrote:
> From a Slony-I users standpoint - the idle transactions cause
> pg_listener bloat, which can impact replication performance on busy sites.
I think that problem has a different solution, which is to rewrite the
listen/notify mechan
Tom Lane wrote:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
On Tue, Jul 19, 2005 at 10:44:35PM -0400, Tom Lane wrote:
If it's a matter of whether VACUUM removes rows or not, that's expected:
open-transaction bookkeeping is done across the whole cluster. (This is
not something simple to
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Jul 19, 2005 at 10:44:35PM -0400, Tom Lane wrote:
>> If it's a matter of whether VACUUM removes rows or not, that's expected:
>> open-transaction bookkeeping is done across the whole cluster. (This is
>> not something simple to change, since we
Hello,
(Sorry my english)
I saw this words in my 'ps -Af'. JBOSS use jdbc driver for postgres.
In java the Connection has a method: setAutoCommit(boolen).
Those connections where autocommit=false, and after the last sql
command (select, insert, update) NOT have rollback or commit, state
will "id
On Tue, Jul 19, 2005 at 10:44:35PM -0400, Tom Lane wrote:
> If it's a matter of whether VACUUM removes rows or not, that's expected:
> open-transaction bookkeeping is done across the whole cluster. (This is
> not something simple to change, since we may have to consider
> transaction IDs in share
FM <[EMAIL PROTECTED]> writes:
> What is strange is that users on all DB (not only DB1) are affected by
> the JBOSS .
> I understand that it locked DB1 but why it also locked users on others DB ?
You should define "locked" more carefully: exactly what behavior are you
seeing that you don't like?
FM wrote:
> What is strange is that users on all DB (not only DB1) are affected
> by the JBOSS .
> I understand that it locked DB1 but why it also locked users on
> others DB ?
This is fairly impossible. Please show us more concrete evidence of
what you are observing.
--
Peter Eisentraut
http:
Hello,
We are using JBOSS and postgresql on 1 database (DB1). From time to time
the JBOSS process .
What is strange is that users on all DB (not only DB1) are affected by
the JBOSS .
I understand that it locked DB1 but why it also locked users on others DB ?
Thanks !
FM <[EMAIL PROTECTED]> writes:
> How can I clan lod blobs from database ?
LOs don't go away just because they aren't referenced anywhere;
an explicit delete has to be issued.
You probably want to use contrib/vacuumlo.
regards, tom lane
---(end of
Hello,
I had a large DB (db1) 12 GB using Blobs. To remvoe old large objects I
connected to db1 and did a . But the database size
is still 12GB.
How can I clan lod blobs from database ?
Thanks
---(end of broadcast)---
TIP 5: Have you checked ou
On Sun, Mar 27, 2005 at 13:24:34 +0800,
Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
> >I'm looking for an existing function which allows me to search the nearest
> >neighbours of the requested value.
>
> Well you could try something like:
>
> SELECT * FROM table ORDER BY ABS(val - 2) LIM
I'm looking for an existing function which allows me to search the nearest
neighbours of the requested value.
Well you could try something like:
SELECT * FROM table ORDER BY ABS(val - 2) LIMIT 1;
That doesn't get you all the way there, but it's an idea...
Chris
---(end of br
--- prabhath g <[EMAIL PROTECTED]> wrote:
> Dear Sir,
>
>
> Thanks for replying my previous query, I was
> able to successfully install the server and am
> accessing through pgadmin III.
>
> Now I want to install client version on other
> machines. Client version of linux or versions bel
Dear All
My name is Yosi Aditya Sembada. recently I'm
developing DRP with postgresql using postgresql
replicator. After I have installed pgreplicator on my
computer, I try to create a database replication with
"createdbr" command. I'm having the following error
when I execute this command
[EMAIL P
The world rejoiced as [EMAIL PROTECTED] (Bryan Biggers) wrote:
> Can anyone tell me what the data file names with the .1 .2 .3
> etc. extensions are? Are these undo versions of my tables or
> something? I need to recover some disk space and I'm wondering if I
> need them. Here is an example...
> -r
On Tue, 19 Oct 2004, Bryan Biggers wrote:
> Can anyone tell me what the data file names with the .1 .2 .3 etc.
> extensions are? Are these undo versions of my tables or something? I
> need to recover some disk space and I'm wondering if I need them. Here
> is an example...
> -rw---1 postg
Bryan Biggers <[EMAIL PROTECTED]> writes:
> Can anyone tell me what the data file names with the .1 .2 .3 etc.
> extensions are? Are these undo versions of my tables or something? I
> need to recover some disk space and I'm wondering if I need them.
You will be very very unhappy if you remove th
while you weren't looking, Bryan Biggers wrote:
> Can anyone tell me what the data file names with the .1 .2 .3 etc.
> extensions are? Are these undo versions of my tables or something? I
> need to recover some disk space and I'm wondering if I need them.
Delete them at your peril.
Really quick
Can anyone tell me what the data file names with the .1 .2 .3 etc.
extensions are? Are these undo versions of my tables or something? I
need to recover some disk space and I'm wondering if I need them. Here
is an example...
-rw---1 postgres postgres 1073741824 Oct 18 20:01 19523580
-rw--
Dear Pedro ,
Hello. this is my "first" time using pgsql, and I seem to be running
to a bit of a corner here :-)
I've understood how to add a superuser/database-user/user but I have
no user to begin with.
~# createuser superuser
Shall the new user be allowed to create databases? (y/n) y
Shall th
That was it - user 'postgres', owner of postmaster, has got what it takes.
Thank you for solving my problem and giving me some extra tips to work on.
I will now continue lurking on the ML and watching closely your
discussions. Good bye then :-)
---(end of broadcast)---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pedro Almeida írta:
| kaolin fire wrote:
|
|> try user 'pgsql' :) that's the default initially created superuser, no
|> password (it would be good to give it one).
|>
|> -kaolin fire
|> -http://erif.org/code/fallingup/ for a 'spin' on tetris
|>
|>
| Tha
Pedro Almeida wrote:
> So I need someway to add a user so I can add others.
There should be a predefined user named "postgres".
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
kaolin fire wrote:
try user 'pgsql' :) that's the default initially created superuser, no
password (it would be good to give it one).
-kaolin fire
-http://erif.org/code/fallingup/ for a 'spin' on tetris
That was a quick response :-)
using a clean pg_hba.conf file (no user lines added), this is
Hello. this is my "first" time using pgsql, and I seem to be running to
a bit of a corner here :-)
I've understood how to add a superuser/database-user/user but I have no
user to begin with.
~# createuser superuser
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be
please forward
2004-01:[by date] [by thread]
2003-12:[by date] [by thread]
many thanks
ratnavale
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unr
After a long battle with technology, [EMAIL PROTECTED] (Renney Thomas), an earthling,
wrote:
> Has anyone any experience with PGSQL 7.x and implenting the FTC
> do-not-call list - which is about 50 million 10 digit N. American
> phone numbers? If so what structures have you used and what have you
Renney Thomas wrote:
> Has anyone any experience with PGSQL 7.x and implenting the FTC
> do-not-call list - which is about 50 million 10 digit N. American phone
> numbers? If so what structures have you used and what have you done
> interms of performance tweaks? Is there an equivalent to Oracle
Has anyone any experience with PGSQL 7.x and implenting the FTC
do-not-call list - which is about 50 million 10 digit N. American phone
numbers? If so what structures have you used and what have you done
interms of performance tweaks? Is there an equivalent to Oracle's IOT
(index organized tabl
On Tue, Nov 04, 2003 at 03:40:21PM -0600, Bruno Wolff III wrote:
> On Tue, Nov 04, 2003 at 15:27:23 +,
> Rob Fielding <[EMAIL PROTECTED]> wrote:
> > I keep doing this because I keep forgetting the Reply-To field isn't set
> > to the pgsql- mailing list.
>
> Its not. You should probably jus
On Tue, Nov 04, 2003 at 15:27:23 +,
Rob Fielding <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm currently subscribed to pgsql-general and wheneven every I hit
> reply, I keep forgetting to reply-to-all so that my mail client includes
> a cc to the pgsql-general list.
>
> I keep doing this becau
Hi,
I'm currently subscribed to pgsql-general and wheneven every I hit
reply, I keep forgetting to reply-to-all so that my mail client includes
a cc to the pgsql-general list.
I keep doing this because I keep forgetting the Reply-To field isn't set
to the pgsql- mailing list.
I was wondering
If you're using Linus, change those settings (semaphores) with a
root account.
Edit /etc/sysctl.conf to add the setting below (adjust the value
properly)
kernel.shmmni =
kernel.shmmax =
Execute
sysctl -p
Good luck,
Anis WN
15 Mbytes Free We
this means. How do I solve this?
>
> What SHMMAX and SHMMIN and how I calculate this value? I have a 1GB of
> memory.
>
> Regards,
> ganesh
>
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of sc
ve this?What SHMMAX and SHMMIN and how I calculate
this value? I have a 1GB of
memory.Regards,ganesh-Original
Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of scott.marloweSent: Tuesday, October 07, 2003 10:36 PMTo:
Ganesan KanavathyCc: [EMAIL PROTECTED]Subject:
1 - 100 of 152 matches
Mail list logo
