This is a bit off topic for the Postgres list... ;)
Make sure you explicitly include the name of the Lucene jar file in your
command line invocation, and any other directories that are required
(normally your current working directory), so for Windows you'd use
something like
java -cp .;{pat
Haroon Sayyad wrote:
Dear Sir, Please help us and guide us to solve following error while
using postgres 8.3 version. Error showing is
'invalid page header in block 102 of relation pg_proc'
There is no PostgreSQL version 8.3 - please check again.
The error message suggests on-disk corruption.
Jasbinder Bali wrote:
Hi,
I'm using pgadmin 3 in fedora core 4.
Whenever i try to open postgres help, pgadmin shuts down abnormally.
The same thing happens when i try to view postgresql.conf or pg_hba.conf
files.
Don't know whats going wrong.
If you start pgadmin from a terminal, you might see
Title: Re: [GENERAL] B+ versus hash maps
in that case, should i set
enable_seqscan parameter to off at the time
of starting postmaster?
because i have seen that even thou the
index exists it still goes for seq scan
thanks
surabhi
From: Jim Nasby
[mailto:[EMAIL PROTECTED]Sent: Fri 6
On Tue, Jun 13, 2006 at 05:01:01PM +0200, Daniel McBrearty wrote:
> create table translations (
> id serial primary key
> );
> insert into table translations ... insert what?
insert into translations default values;
> The other way to do this that I see is to lose the link table
> translations_
Anyone have any tips for minimizing downtime when upgrading? So far
we have done upgrades during scheduled downtimes. Now we are getting
to the point where the time required for a standard dump/restore is
just too long. What have others done when downtime is critical? The
only solution we have
Tom Lane wrote:
Chander Ganesan <[EMAIL PROTECTED]> writes:
I'd like to suggest that a feature be added to pg_dumpall to remove
tablespace definitions/creation from the output. While the inclusion is
important for backups - it's equally painful when attempting to migrate
data f
Chander Ganesan <[EMAIL PROTECTED]> writes:
> I'd like to suggest that a feature be added to pg_dumpall to remove
> tablespace definitions/creation from the output. While the inclusion is
> important for backups - it's equally painful when attempting to migrate
> data from a development to prod
""Relyea, Mike"" <[EMAIL PROTECTED]> wrote
> Is this what you're looking for?
No. I mean per-context memory usage output like this in your log file:
2006-06-08 16:33:09 LOG: autovacuum: processing database "ibox"
TopMemoryContext: 84400 total in 7 blocks; 12696 free (22 chunks); 71704
used
Oper
John Gunther <[EMAIL PROTECTED]> writes:
> Question: Aside from "dollar quoting" (Section 4.1.2.2), is there any
> way NOW to force backslashes in string constants to be treated as
> ORDINARY characters?
Not in current releases. CVS tip (8.2-to-be) does have that ability.
Bear in mind though th
I'd
like to suggest that a feature be added to pg_dumpall to remove
tablespace definitions/creation from the output. While the inclusion
is important for backups - it's equally painful when attempting to
migrate data from a development to production database. Since
PostgreSQL won't create the
Hi John,
I have had a read through the lucene website
(http://lucene.apache.org/java/docs/index.html) and it sounds pretty
good to me. I should be able to use this in conjuction with my JSP
pages.
This may sound quite dumb to anyone who develops in java, but I need a
little help setting up the de
Hi
I have started to use ldap for user authentication on my systems.
1 is it possible to get postgres to authenticate against ldap
2 is it advisable to do this ?
Alex
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi,
I have a database
where there are three columns (name,date,data). The queries are almost
always something like SELECT date,data FROM table WHERE name=blah AND date >
1/1/2005 AND date < 1/1/2006;. I currently have three B-tree
indexes, one for each of the columns. Is clustering on d
Doc section 4.1.2.1 says that in future, backslashes will be treated as
ordinary string characters. It says to use the "E" string prefix to
ensure that backslashes are permanently treated as escape characters.
Question: Aside from "dollar quoting" (Section 4.1.2.2), is there any
way NOW to for
Hi
I am in the process of rolling out ldap on my servers for
authentication, I was wondering is it possible to have postgres to
authenticate against ldap. Is this even a sane thing to do.
I was thinking something similar to the way my linux boxes are setup.
All normal users in the ldap tree and
The article on the subject can be read here:
http://linux.inet.hr/optimize_postgresql_database_size.html
Comments most welcome!
---(end of broadcast)---
TIP 6: explain analyze is your friend
Tom Lane a écrit :
> [EMAIL PROTECTED] writes:
> > I'm experiencing a strange problem with PostgreSQL 7.4.9.
> > One of my database production servers has 2 large databases, it's still
> > possible to connect to them and pass queries, but the pg_database
> > system table is empty, which prohibits
Dear Sir, Please help us and guide us to solve following error while using postgres 8.3 version. Error showing is 'invalid page header in block 102 of relation pg_proc' __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection aro
Hi
I have a table "phrases" that looks like this :
create table phrases(
id serial ,
language integer references langauges(id),
content text
);
Simply a word or phrase in some language.
Now I want to express the concept of a "translation". A translation is
a number of phrases from differen
On Jun 15, 2006, at 1:16 PM, Florian G. Pflug wrote:
Nitin Verma wrote:
Were these bugs fixed by 7.3.2, if not what version should I look
for?
http://archives.postgresql.org/pgsql-admin/2001-06/msg5.php
http://archives.postgresql.org/pgsql-hackers/2000-04/msg00083.php
Ahm... 7.3.2 is *v
On Jun 15, 2006, at 7:09 AM, JahMic wrote:
Whenever I enter 'psql', I keep getting these "could not find a
"psql" to execute" messages and then it proceeds to exec the psql
program. If I enter 'psql' by itself, I will get this message
twice before continuing the psql program.
This is on
On Jun 15, 2006, at 8:07 AM, surabhi.ahuja wrote:
is there any way of specifying wht type of index i want, say hash
maps instead of the B+ trees.
someone told me that in the case where duplicates occur(on the
indexed field), hash map are better than B+ trees.
http://www.postgresql.org/docs/
You can use EXPLAIN and EXPLAIN ANALYZEFor details please have a look at --> http://www.postgresql.org/docs/8.1/interactive/performance-tips.html
/ShoaibOn 6/16/06, shyju c.k <[EMAIL PROTECTED]> wrote:
hai all
plz send gen info abt query optimizer technic in postgresql
with example
Title: Nachricht
What
EXACTLY do you mean under "query optimizertechnic " ?
Regards. Milen
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of shyju c.kSent: Thursday, June 15, 2006 10:11
PMTo: pgsql-general@postgresql.orgSubject: [GENE
When you are logged in as user 'postgres' then you can run the pg_ctl reload like this:pg_ctl -D reload/ShoaibOn 6/16/06,
LLC <[EMAIL PROTECTED]> wrote:
You cannot use the postgres account without some tweaks, Sorry I don't remember where I found this info - somewhere in the pgadmin install docs.
hai all
plz send gen info abt query optimizer technic in postgresql
with example
You cannot use the postgres account without some tweaks, Sorry I don't remember where I found this info - somewhere in the pgadmin install docs.
Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine
- Original Message -
"Christopher Murtagh" <[EMAIL PROTECTED]> writes:
> The difference between my 7.4.6 and 8.1.4 DBs was that 7.4.6 had
> UNICODE as it's encoding, whereas the 8.1.4 was UTF8.
I don't think so, because those are the same thing. We just adopted a
more technically-correct name for the encoding.
My re
Hi Listers,
I am playing a little bit more with partioning (constraint exclusion) in tha
last days.
I have tried with one-level partioning (one parent table + 2 inherited tables).
Worls like a charm.
I want to go further, I and wanted to test sub-partiotioning (grandchild
tables of the master
Hey, I solved my own problem! I'm posting here because while I was
looking for solutions, I found tons of folks tackling the same
problem, most didn't find the solution or had to do cumbersome
'translate()'s to get what they wanted.
The difference between my 7.4.6 and 8.1.4 DBs was that 7.4.6 had
Change the following in pg_hba.confhost all all 127.0.0.1/32 md5to host all all 127.0.0.1/32
trustand that will let you connect without password and then reload your db server settings using 'pg_ctl reload'. You can then set the password once
Hi,
I'm using pgadmin 3 in fedora core 4.
Whenever i try to open postgres help, pgadmin shuts down abnormally.
The same thing happens when i try to view postgresql.conf or pg_hba.conf files.
Don't know whats going wrong.
Thanks,
~Jas
On Thu, 2006-06-15 at 13:24, Jasbinder Bali wrote:
> Hello,
> > I'm trying to connect to the local postgres database using pgadmin.
> It
> > asks for a password that i never set and hence i'm not able to
> connect
> > to my local postgres database.
> > Also, when i click postgresql help option in t
Hello,> I'm trying to connect to the local postgres database using pgadmin. It> asks for a password that i never set and hence i'm not able to connect> to my local postgres database.
> Also, when i click postgresql help option in the Help tab of pgadmin,> the pgadmin screen would close down. Don't
Nitin Verma wrote:
Were these bugs fixed by 7.3.2, if not what version should I look for?
http://archives.postgresql.org/pgsql-admin/2001-06/msg5.php
http://archives.postgresql.org/pgsql-hackers/2000-04/msg00083.php
Ahm... 7.3.2 is *very* outdated. The current version of postgresql is
8.1.
Were these bugs fixed by 7.3.2, if not what version should I look for?
http://archives.postgresql.org/pgsql-admin/2001-06/msg5.php
http://archives.postgresql.org/pgsql-hackers/2000-04/msg00083.php
It would be gr8 if can myself look into bug list next time before asking
questions, any URL?
-
Is there a workaround for any of these?
-Original Message-
From: Nitin Verma
Sent: Thursday, June 15, 2006 11:03 PM
To: pgsql-general@postgresql.org
Subject: VACUUMing sometimes increasing database size / sometimes crashing it
Were these bugs fixed by 7.3.2, if not what version should
Nis Jorgensen wrote:
> Martijn van Oosterhout wrote:
>
> > I beleive there is a regexp_replace. In psql, if you type \df you get a
> > list of all defined functions. The docs have info too.
>
> The function is confusingly not mentioned in the documentation under
> "String Functions and Operators"
Greetings folks,
I'm trying to write a stored procedure that strips accents from UTF-8
encoded text. I saw a thread on this list discussing something very
similar to this on April 8th, and used it to start. However, I'm
getting odd behaviour.
My stored procedure:
CREATE OR REPLACE FUNCTION stri
Martijn van Oosterhout wrote:
# select replace('aac','a','b');
replace
-
bbc
(1 row)
So replace(str, '\r', '\\r') should work
Perfect, thanks.
I guess I'm blind, I didn't see this in the docs. :)
-Jon
--
-**-*-*---*-*---*-*---*-*-*-*---*-*---*-*-*-*-*---
Jo
Martijn van Oosterhout wrote:
> I beleive there is a regexp_replace. In psql, if you type \df you get a
> list of all defined functions. The docs have info too.
The function is confusingly not mentioned in the documentation under
"String Functions and Operators", but only under "Pattern Matching"
On Thu, Jun 15, 2006 at 11:51:21AM -0300, Jon Lapham wrote:
> So, as I understand it (please correct me if I'm wrong), UNIX uses a
> "newline" (or \n), Mac uses "carriage return" (or \r) and Win/DOS uses
> \r\n.
Correct.
> 1) Does anyone know why the "id" column is not visible for the final
>
I have a database that needs to work with TEXT input generated from a
heterogeneous environment (UNIX, Win, Mac). As such, I have noticed
that equality comparisons of supposedly identical TEXT is failing due to
the different line terminators embedded in some TEXT fields.
So, as I understand i
On Thu, Jun 08, 2006 at 07:25:35AM -0400,
Douglas McNaught <[EMAIL PROTECTED]> wrote
a message of 29 lines which said:
> I would think it would (at least potentially) vary with each
> message. The dbmail software should really set client_encoding
> based on the Content-Transfer-Encoding header
Title: Re: [GENERAL] delete seems to be getting blocked
is there any way of
specifying wht type of index i want, say hash maps instead of the B+
trees.
someone told me that in the case where
duplicates occur(on the indexed field), hash maps are better than B+
trees.
and also please tell i
Yavuz Kavus wrote:
hi everybody.
i am writing stored procedures.
lots of them have out parameters.
i dont know how to test them
from an sql query tool(ex: pgAdmin query tool).
i am trying to test them from my program, but it is not so efficient.
i want to test from a query tool.
i can do
Whenever I enter 'psql', I keep getting these "could not find a "psql" to
execute" messages and then it proceeds to exec the psql program. If I enter
'psql' by itself, I will get this message twice before continuing the psql
program.
This is on a Windows machine. Note, this doesn't happen, if
On 6/15/06, Richard Huxton wrote:
Yavuz Kavus wrote:
> hi everybody.
>
> i am writing stored procedures.
> lots of them have out parameters.
>
> i dont know how to test them
> from an sql query tool(ex: pgAdmin query tool).
> i am trying to test them from my program, but it is not so efficient.
On Jun 15, 2006, at 15:52 , Johan van der Merwe wrote:
My code is as follows:
Could you explain a bit more what this code is? Is it Java? Python?
What does it do? I know it's not SQL, and I'm guessing it's some kind
of ORM, but without more information I really don't know how to help
(a
Yavuz Kavus wrote:
hi everybody.
i am writing stored procedures.
lots of them have out parameters.
i dont know how to test them
from an sql query tool(ex: pgAdmin query tool).
i am trying to test them from my program, but it is not so efficient.
OUT parameters get returned as part of a record
shyju c.k wrote:
hai
have to solve one problem
i have two mechine in diffrent network range , one is main database
server(n/w is 10.1.2.0) and other is back bone server(n/w 10.1.7.0)
i need to take pg_dump from back bone server .
what configuration needed in pg_hba.conf
On 10.1.2
Johan van der Merwe wrote:
I have posted this before without receiving replies
Can't see it in the archives. Were you subscribed?
My code is as follows:
Public dbRemote As New Connection
Public rsData As New Recordset
dbRemote.Properties("Data Source").Value = "DSM"
dbRemote.Properties("Ini
53 matches
Mail list logo
