On Mon, 2006-10-23 at 02:11 -0400, brian wrote:
> pg_controldata - display control information of a PostgreSQL database
> cluster
>
> pg_controldata [ datadir ]
I was hoping for the actual command but this suggests deduction ;-)
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
652
Joost Kraaijeveld wrote:
Is it possible to find out the parameters used with initdb on an old
database or is this a matter of deduction?
TIA
pg_controldata - display control information of a PostgreSQL database
cluster
pg_controldata [ datadir ]
brian
---(end of b
Is it possible to find out the parameters used with initdb on an old
database or is this a matter of deduction?
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl
---(end o
Ritesh Nadhani wrote:
Hello
A newbie to PostgreSQL from MySQL and just trying to learn tsearch2. In
one of the examples at:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
the query given is:
SELECT intindex, strTopic FROM tblmessages
WHE
"Low Kian Seong" <[EMAIL PROTECTED]> writes:
> On 10/23/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>> pg_config --configure | grep -e '--without-zlib'
> I am using pclinuxos and it seems to come without pg_config.
It might be in the -devel RPM.
If it's not there at all, get a real linux distro ...
On 10/23/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Low Kian Seong" <[EMAIL PROTECTED]> writes:
> My question, if we are using binaries on a rpm based system and without
> looking at the src.rpm is there a way to query the postgresql server to find
> out whether it was built against the zlib compre
Alvaro Herrera wrote:
> Javier Carlos wrote:
> >Hi,
> >
> >Does anybody know what's the meaning of the c (lowercase) privilege in
> > PostgreSQL 8.2 Beta?
>
> "connect"
And it is listed in the 8.2 documentation.
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDBhttp://www.enterp
On Mon, Oct 23, 2006 at 08:27:46AM +0800, carter ck wrote:
> Currently I am ancountering a sequnce error. THe sequence number is being
> used up to 573, but, suddenly and unexpectedly, when I issue the select
> nextval command, it gives the value of 400, which is currently occupied by
> a record
what type of start up script are you talking about here?
On 10/21/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Ian Harding" <[EMAIL PROTECTED]> writes:
> On 10/20/06, Tom Lane <[EMAIL PROTECTED]> wrote:>> Personally I think the TIP that's really needed is "never remove>> postmaster.pid by hand".
> When
I have a column of information that is being deleted after
I have initiated the run sequences on my host application. (The application is
in development.)
I have seen list messages about a PostgreSQL log that is
available. Can someone point me to documentation to access this log. It may giv
On Sunday 22 October 2006 12:32, Volkan YAZICI wrote:
> On Oct 20 05:07, [EMAIL PROTECTED] wrote:
> > I'm concerned about whether the usual parameter escaping mechanism is
> > enough in a LIKE or regular expression search.
> >
> > I run a recent Postgres version and use the Python connector psycopg
Bob Pawley wrote:
I have a column of information that is being deleted after I have
initiated the run sequences on my host application. (The application
is in development.)
I have seen list messages about a PostgreSQL log that is available.
Can someone point me to documentation to access this lo
"Wes Sheldahl" <[EMAIL PROTECTED]> writes:
> I seem to have an unstable/unreliable installation of postgresql, and I'm
> not sure how to troubleshoot it.
> Symptoms:
> $ psql postgres
> psql: FATAL: semctl(851974, 3, SETVAL, 0) failed: Invalid argument
AFAICS the only documented reason for that s
Hi all,
Currently I am ancountering a sequnce error. THe sequence number is being
used up to 573, but, suddenly and unexpectedly, when I issue the select
nextval command, it gives the value of 400, which is currently occupied by a
record.
I am looking forward for any possible solution to sol
On Oct 20 05:07, [EMAIL PROTECTED] wrote:
> I'm concerned about whether the usual parameter escaping mechanism is
> enough in a LIKE or regular expression search.
>
> I run a recent Postgres version and use the Python connector psycopg2
> for a web application. I understand that if I always escap
On Sun, Oct 22, 2006 at 06:24:43PM +0200, Alex Mayrhofer wrote:
> Hi,
>
> Two short questions:
>
> 1) What storage size does the "bit(n)" data type have? Is it one byte per 8
> bits (plus a "length" byte)? I didn't find this in neither the docs nor the
> list archives ...
It'll be a varlena stru
Hi,
Two short questions:
1) What storage size does the "bit(n)" data type have? Is it one byte per 8
bits (plus a "length" byte)? I didn't find this in neither the docs nor the
list archives ...
2) Additionally, how much storage space does a functional index which
returns "boolean" approx. take?
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Ron Johnson wrote:
>> That implies malice. The people at OpenCRX apparently really
>> believe what they wrote.
> I believe they probably do believe it and it was probably driven by a
> complete lack of understanding of PostgreSQL.
> It doesn't hav
"Low Kian Seong" <[EMAIL PROTECTED]> writes:
> My question, if we are using binaries on a rpm based system and without
> looking at the src.rpm is there a way to query the postgresql server to find
> out whether it was built against the zlib compression library ?
pg_config --configure | grep -e '-
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/22/06 06:45, Thomas Hallgren wrote:
Joshua D. Drake wrote:
Tomi NA wrote:
I was just reading http://www.opencrx.org/faq.htm where RDBMS engines
are one of the questions and see pgsql bashed sentence after sentence.
Can any
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/22/06 06:45, Thomas Hallgren wrote:
> Joshua D. Drake wrote:
>> Tomi NA wrote:
>>> I was just reading http://www.opencrx.org/faq.htm where RDBMS engines
>>> are one of the questions and see pgsql bashed sentence after sentence.
>>> Can anyone off
Joshua D. Drake wrote:
Tomi NA wrote:
I was just reading http://www.opencrx.org/faq.htm where RDBMS engines
are one of the questions and see pgsql bashed sentence after sentence.
Can anyone offer any insight as to weather it's fact or FUD?
It is 100% FUD.
What would be the incentive for Open
On Sun, Oct 22, 2006 at 09:55:23AM +0200, Thomas Pundt wrote:
> On Sunday 22 October 2006 09:43, Low Kian Seong wrote:
> | It says in the postgresql 8 documentation :
> |
> | "If PostgreSQL was built on a system with the zlib compression library
> | installed, the custom dump format will compress d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/22/06 04:39, Jeffrey Webster wrote:
> On 10/20/06, Jean-Christophe Roux <[EMAIL PROTECTED]> wrote:
>>
>> Hello,
>> [snip]
>>
>
>
>
> none of them will be inserted because the first insert is a primary key
>> violation. How can I have postgreSQ
On 10/20/06, Jean-Christophe Roux <[EMAIL PROTECTED]> wrote:
Hello,[snip]
none
of them will be inserted because the first insert is a primary key
violation. How can I have postgreSQL not mind about the error and
proceed to the next insert. I could send the inserts one at a time but
bundling them
On Sunday 22 October 2006 09:43, Low Kian Seong wrote:
| It says in the postgresql 8 documentation :
|
| "If PostgreSQL was built on a system with the zlib compression library
| installed, the custom dump format will compress data as it writes it to the
| output file"
|
| My question, if we are usi
Dear all,It says in the postgresql 8 documentation :"If PostgreSQL was built on a system with the zlib compression library installed, the custom dump format will compress data as it writes it to the output file"
My question, if we are using binaries on a rpm based system and without looki
27 matches
Mail list logo
