Jared Evans wrote:
perhaps you misunderstood my question. I downloaded a binary package
off the Debian website. How do I determine what options it was
compiled with? That is my question.
Look inside the source package in debian/rules.
---(end of
Hello Scott,
thank you for this link. But I wonder, do I need to do this if postgres has
never actually been used by any user of this server in the past?
This is what happened when I tried each step of that page:
2. pg_dumpall file.txt
I received this error:
pg_dumpall: could not connect
Hi,
I'm trying to upgrade postgres to 7.4.2. I've dumped the
database on 7.2.1 but when I try to recreate it by doing
psql -e template1 db.sql
as user 'postgres', I get
DELETE FROM pg_shadow WHERE usesysid (SELECT datdba FROM pg_database
WHERE datname = 'template0');
DELETE 15
CREATE USER
Hi all
I am looking for the cookbook mentioned in techdocs. I have been trying
for a few days now and keep getting en error 500 from the website
whether I go through the proxy at work or via dialup. Is it maybe
mirrored somewhere else or available as a pdf?
Kind Regards
Craig
On Thu, May 13, 2004 at 04:19:36PM +0200, Laurens Wagemakers wrote:
Hai Tom,
I just talked to the developers and we can use 7.1 now.
I'd still counsel you very strongly to upgrade somewhat higher.
There are an awful lot of bugs from those days. But in any case, you
might want to grovel
Hi,
Does anyone know how to set timestamp values in
postgres.
Thanks in Advance.
- Priya
__
Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price.
http://promo.yahoo.com/sbc/
---(end of
Interesting article on May Linux Journal ( pag 44 ):
[...]
we installed Spamity, which parses mail logs from the four
Postfix servers and update a Postgresql database running on
the test server
[...]
Regards
Gaetano Mendola
---(end of
Hi... first sorry by my english.
I have installed a postgresql 7.4.2, and when try to up in ssl mode this
not up. then comment the ssl line in postgresql.conf and this start
correctly.
what can do ???
Thank
--
Ing. Mario Soto Cordones
Venezolana de Avaluos
www.venezolanadeavaluos.com
Hi,
Im running postgres 7.4.3 on HP-UX 11.11. When I want
to connect to my db, I have the following error:
psql: FATAL: _mdfd_getrelnfd: cannot open relation
pg_class: Permission denied
Do you have any idea where i have to look. I already
looked at pg_hba.conf file and it looks
Mario Alberto Soto Cordones wrote:
I have installed a postgresql 7.4.2, and when try to up in ssl mode
this not up. then comment the ssl line in postgresql.conf and this
start correctly.
Tell us the error messages, then we can maybe help you.
---(end of
Hi don´t say error only not start
Thank
Mario Alberto Soto Cordones wrote:
I have installed a postgresql 7.4.2, and when try to up in ssl mode
this not up. then comment the ssl line in postgresql.conf and this
start correctly.
Tell us the error messages, then we can maybe help you.
Hi Mario,
Did you remember to create SSL certificates, place them in your
pgsql/data directory and set permissions on those files?
This is what keeps PG from firing up in SSL mode (on my setup, at least).
HTH,
-- Mitch
Mario Alberto Soto Cordones wrote:
Hi don´t say error only not start
Thank
Hi,
the certificate was create in the directori of data, an the permision its
to user postgres.
but the database not start
Thank
Mario
Hi Mario,
Did you remember to create SSL certificates, place them in your
pgsql/data directory and set permissions on those files?
This is what keeps PG
Mario Alberto Soto Cordones wrote:
Hi,
the certificate was create in the directori of data, an the permision its
to user postgres.
but the database not start
Not sure if this is supposed to go on the list, so send me your
pg_hba.conf and postgresql.conf files (off-list). I believe you have an
I am trying to allow individuals within a PostgreSQL (v7.4) group to
connect to the backend. The relevant line in pg_hba.conf is (I
believe):
hostdb+groupIP address/32 md5
Note that I have replaced the contents of the real fields with ...,
but that these match across
Hello all:
I have a database that is exhibiting sluggishness under load. Suspecting
that some queries may be poorly optimized, I turned on a fair amount of
debugging output in the logs. But I could use some help interpreting it.
For the record, this is Postgres 7.2.1. I've already been rightly
Nico De Ranter [EMAIL PROTECTED] writes:
\connect: FATAL: IDENT authentication failed for user nico
I changed /etc/postgresql/pg_hba.conf so it only contains
localall all trust=20
and restarted postgres but I still get the same error message.
Any idea why the import complains
Steve Lane [EMAIL PROTECTED] writes:
I have a database that is exhibiting sluggishness under load. Suspecting
that some queries may be poorly optimized, I turned on a fair amount of
debugging output in the logs. But I could use some help interpreting it.
I think you're going at this all wrong.
Maybe this will help.
http://www.postgresql.org/docs/7.4/static/datatype-datetime.html
On Tue, 2004-05-18 at 09:17, Hemapriya wrote:
Hi,
Does anyone know how to set timestamp values in
postgres.
Thanks in Advance.
- Priya
From: Tom Lane [EMAIL PROTECTED]
Date: Tue, 18 May 2004 21:06:43 -0400
To: Steve Lane [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Interpreting query debug output
Steve Lane [EMAIL PROTECTED] writes:
I have a database that is exhibiting sluggishness under load.
20 matches
Mail list logo