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 broadcast)---
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 t
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 (SELECT datdba FROM pg_database
WHERE datname = 'template0');
DELETE 15
CREATE USER "ids" WITH SYSID 103 PASSWORD 'Yil8t8Wq1yFth' NOCREATEDB
NOCREATEUSER;
CR
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 th
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 broadcast)
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 broadcast)---
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 ok.
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 broadcast)--
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
Ma
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 kee
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
er
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):
host+/32 md5
Note that I have replaced the contents of the real fields with <...>,
but that these match across what follows. I un
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 c
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 comp
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 wr
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 l
20 matches
Mail list logo
