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
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
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
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
Jasbinder Bali wrote:
well, i start it from anywhere, it would close abnormally..
And you don't get an error message in the terminal? Not even process
exited on signal XXX?
SELinux is interfering? like how?
It sets policies for what applications can access what files/other
resources. It
snacktime wrote:
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
Will 7.3.2 Dump made up of copies using pg_dump import without any migration
to 8.0+? What I need isn't a once process and will go as a automated script,
in a way that user will not even get to know (if he isn't reading that logs)
Database version changed. Considering that even a remote problem
Hi
I have started to use ldap for user authentication on my systems.
1 is it possible to get postgres to authenticate against ldap
Yes. With current releases you can do this with PAM, assuming you're on
a platform that can do PAM. If your platform can't do PAM (for example,
Windows), you
Alban Hertroys wrote:
Hi all,
We're using some 3rd party product that uses inheritence, and the
following query is rather slow on PostgreSQL 7.4.7 (debian stable). Any
suggestions how to speed it up?
We really need this solved. Isn't anybody able to shed some light on
this? Is it possible
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 force
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.
However this works:
Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine
/Kevin
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
DataIntellectSent: 15 June 2006 20:56To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] postgres
password
You cannot use the postgres account without some tweaks, Sorry I don't
remember where I
snacktime wrote:
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
Nitin Verma [EMAIL PROTECTED] writes:
Will 7.3.2 Dump made up of copies using pg_dump import without any migration
to 8.0+? What I need isn't a once process and will go as a automated script,
in a way that user will not even get to know (if he isn't reading that logs)
Database version
Douglas McNaught wrote:
Nitin Verma [EMAIL PROTECTED] writes:
Will 7.3.2 Dump made up of copies using pg_dump import without any migration
to 8.0+? What I need isn't a once process and will go as a automated script,
in a way that user will not even get to know (if he isn't reading that logs)
On Thu, 15 Jun 2006, snacktime wrote:
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
if your application depends on things that changed between 7.3 and 8.1.
Postgres tends to become more strict with every release, so
there are things you got away with in 7.3 which now cause an error
message.
Do we have change lists where I can see all the changes between 7.3 and 8.1,
may be
Kenneth Downs wrote:
AFAIK it has always been the case that you should expect to have to dump
out your databases and reload them for version upgrades.
Is anybody over at the dev team considering what an onerous burden this
is? Is anyone considering doing away with it?
Far from trivial. You
Nitin Verma wrote:
if your application depends on things that changed between 7.3 and 8.1.
Postgres tends to become more strict with every release, so
there are things you got away with in 7.3 which now cause an error
message.
Do we have change lists where I can see all the changes between
Chander Ganesan wrote:
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
Magnus Hagander [EMAIL PROTECTED] writes:
8.2 will have direct LDAP authentication without PAM.
That code's going to go away real soon if some documentation doesn't
show up. I can't believe Bruce was sloppy enough to accept a feature
patch with zero documentation.
8.2 will have direct LDAP authentication without PAM.
That code's going to go away real soon if some documentation
doesn't show up. I can't believe Bruce was sloppy enough to
accept a feature patch with zero documentation.
?? I thought I had sent in the docs for that. Will dig through
8.2 will have direct LDAP authentication without PAM.
That code's going to go away real soon if some
documentation doesn't
show up. I can't believe Bruce was sloppy enough to accept
a feature
patch with zero documentation.
?? I thought I had sent in the docs for that. Will
On Wed, 2006-06-14 at 18:34 -0400, Chris Browne wrote:
kleptog@svana.org (Martijn van Oosterhout) writes:
On Tue, Jun 13, 2006 at 05:23:56PM -0400, Christopher Browne wrote:
[3]
http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHSCJUMEKJVN
Magnus Hagander [EMAIL PROTECTED] writes:
Actually, the docs *were* submitted. See
http://archives.postgresql.org/pgsql-patches/2005-12/msg00375.php.
Applied per
http://archives.postgresql.org/pgsql-patches/2006-03/msg00080.php, I
think it's just the docs that were missed.
Ah. I had found
Thanx so much which would really help
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Friday, June 16, 2006 6:29 PM
To: Nitin Verma
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] VACUUMing sometimes increasing database size /
sometimes
Nitin Verma
$ ls -al pgsqldb/pg_xlog
total 32816
drwx--2 nitinverma root 4096 Jun 16 19:53 .
drwx--6 nitinverma root 4096 Jun 16 19:33 ..
-rw---1 nitinverma root 16777216 Jun 16 20:08 0001
-rw---1 nitinverma root 16777216 Jun 16 19:45
In response to Nitin Verma [EMAIL PROTECTED]:
$ ls -al pgsqldb/pg_xlog
total 32816
drwx--2 nitinverma root 4096 Jun 16 19:53 .
drwx--6 nitinverma root 4096 Jun 16 19:33 ..
-rw---1 nitinverma root 16777216 Jun 16 20:08 0001
-rw---
On fös, 2006-06-16 at 11:39 +0530, surabhi.ahuja wrote:
[in response to Jim advising not to set random_page_cost=1]
in that case, should i set
enable_seqscan parameter to off at the time of starting postmaster?
that is unlikely to be a good stategy.
because i have seen that even thou the
Doc patch applied. I must have missed the second attachment.
---
Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
Actually, the docs *were* submitted. See
Should pg_dumpall be using the SET default_tablespace = foo method as
well?
---
Florian G. Pflug wrote:
Chander Ganesan wrote:
Tom Lane wrote:
Chander Ganesan [EMAIL PROTECTED] writes:
I'd like to suggest that a
On Tue, Jun 13, 2006 at 09:04:15 -0700,
Benjamin Arai [EMAIL PROTECTED] wrote:
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
Hi List;
I have 2 questions...
1) I want to create a perl function which connects to an external non-Postgres database and retrieves data. I wonder is the best way to do this to return a set or an array? I assume returning a data set is a better way to go, I want to be able to run something like
Florian G. Pflug wrote:
Chander Ganesan wrote:
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
On 6/16/06, Richard Huxton dev@archonet.com wrote:
The other option would be to run replication, e.g. slony to migrate from
one version to another. I've done it and it works fine, but it will mean
slony adding its own tables to each database. I'd still do it one
merchant at a time, but that
On Wed, Jun 14, 2006 at 13:51:50 -0700,
[EMAIL PROTECTED] wrote:
Starting with this:
create sequence languages_seq increment by 1;
create table languages (
id integer primary key default nextval('languages_seq'),
language_name varchar(100)
);
insert into languages (id,
In response to snacktime [EMAIL PROTECTED]:
On 6/16/06, Richard Huxton dev@archonet.com wrote:
The other option would be to run replication, e.g. slony to migrate from
one version to another. I've done it and it works fine, but it will mean
slony adding its own tables to each database.
Hi List;
I found documentation that talks about untrusted perl here:
http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html
However I do not know how to install/use untrusted perl.
Can someone point me in the right direction?
Thanks in advance...
LLC wrote:
However I do not know how to install/use untrusted perl.
the easiest way is to use createlang from the command line.
for PLperlu just do the following:
(run the command as the postgres user)
su postgrestenter
Then:
createlang plperlu yourdatabasename
It's pretty much the same
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names as f1 and f2.
On Fri, Jun 16, 2006 at 11:42:51AM -0500, LLC wrote:
Hi List;
I have 2 questions...
1) I want to create a perl function which connects to an external
non-Postgres database and retrieves data. I wonder is the best way
to do this to return a set or an array? I assume returning a data
set
On Fri, 2006-06-16 at 12:57, LLC wrote:
Hi List;
I found documentation that talks about untrusted perl here:
http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html
However I do not know how to install/use untrusted perl.
Can someone point me in the right direction?
I have added this URL to the TODO list in case people want to move
forward on this.
---
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
For a while I've been wondering about making a type that was really a
LLC wrote:
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names
Bruce Momjian pgman@candle.pha.pa.us writes:
Should pg_dumpall be using the SET default_tablespace = foo method as
well?
That would mean changing the semantics of CREATE DATABASE; currently it
copies the default tablespace from the template database, rather than
looking at default_tablespace.
1. Section 23.3.2 (Making a Base backup) of the 8.1.0 doc says:
Also, some versions of GNU tar consider it an error if a file is changed
while tar is copying it. There does not seem to be any very convenient way
to distinguish this error from other types of errors, other than manual
inspection of
Trent Shipley wrote:
On Tuesday 2006-06-13 09:26, David Fetter wrote:
On Tue, Jun 13, 2006 at 09:18:17AM -0600, Scott Ribe wrote:
To hold it up as any kind of paradigm is really misinformed.
SQL had something that relational algebra/relational calculus did not
have, which is that somebody
Dear Sir, We are using postgres 8.0.3, on windows xp and we don't have latest database backup. Database shows tables but missing all the procedures written in and shows following error. Also we are using front end PgAdminIII for creating procedures etc. Error is: invalid page header in
In article [EMAIL PROTECTED],
Terry Lee Tucker [EMAIL PROTECTED] wrote:
% elements of 50 thousand records on 8 structurally identical databases. We
% threw together the script and decided to just delete the record and re-insert
% it with the data that was brought into sync. Now the question: Is
Hi,
I'm getting an exception when I'm trying to load a
jar file in Windows XP.
The command I'm using is:
statement.executeUpdate("SELECT
sqlj.install_jar('file:///"+jarLocation+"','"+transformName+"',false)");
where jarLcation is:
C:/temp/transform.jar
The error is:
50 matches
Mail list logo