thanks Greg,
yes, we want SELinux in enforcing mode.
Thereby (and to ensure persistence) just chcon is the wrong way and
* semanage fcontext -a -t postgresql_t ''
* restorecon -vvFR
is much better ;-)
regards--GERD--
On Wednesday, August 04, 2010 07:56:56 am Greg Smith wrote:
> Gerd Koenig wrote
Gerd Koenig wrote:
thanks for the hint, yes, SELinux caused the troubles. It complained about
wrong filecontext while starting postgres via init-script.
Filecontext was: var_lib_t and it should be: postgresql_t
If you want to keep SELinux on, basically you have to relabel the
directory you
On 04/08/10 13:22, Tom Lane wrote:
> Craig Ringer writes:
>> On 03/08/10 23:37, David R Robison wrote:
>>> 2010-08-03 15:34:01 GMT LOCATION: PostmasterMain,
>>> .\src\backend\postmaster\postmaster.c:743
>>> 2010-08-03 15:34:01 GMT DEBUG: 0: TZ "US/Eastern" matches Windows
>>> timezone "Easte
On 04/08/10 03:17, John R Pierce wrote:
> On 08/03/10 12:13 PM, David Kerr wrote:
>> I know that Idle in Transactions are a problem, however I'm trying to
>> assess how much of a problem.
>>
>> for example: If a java program connects to the DB and does "begin;"
>> and then internally does a "sleep
Craig Ringer writes:
> On 03/08/10 23:37, David R Robison wrote:
>> 2010-08-03 15:34:01 GMT LOCATION: PostmasterMain,
>> .\src\backend\postmaster\postmaster.c:743
>> 2010-08-03 15:34:01 GMT DEBUG: 0: TZ "US/Eastern" matches Windows
>> timezone "Eastern Daylight Time"
>> 2010-08-03 15:34:01 G
Hello Greg,
thanks for the hint, yes, SELinux caused the troubles. It complained about
wrong filecontext while starting postgres via init-script.
Filecontext was: var_lib_t and it should be: postgresql_t
regards...GERD
On Tuesday, August 03, 2010 11:54:45 pm Greg Smith wrote:
> Gerd Koenig
On 03/08/10 23:37, David R Robison wrote:
>
> 2010-08-03 15:34:01 GMT LOCATION: PostmasterMain,
> .\src\backend\postmaster\postmaster.c:743
> 2010-08-03 15:34:01 GMT DEBUG: 0: TZ "US/Eastern" matches Windows
> timezone "Eastern Daylight Time"
> 2010-08-03 15:34:01 GMT LOCATION: identify_sys
On 03/08/10 23:18, Santiago Álvarez Martínez wrote:
>
> Hi:
>
> I'm developing a Java application, using Maven, Spring and Hibernate,
> and Postgre (with Postgis) as DBMS.
>
> Everything went OK, until I had to import the org.postgresql.util
> package, to use the PGobject class, in a UserType Hi
Hi fellow PostgreSQL hackers,
First, a thank you to Merlin for commenting on my earlier post!
I've run into another dangerous problem since the earlier post.
I began converting from the plpgsql loop idiom for merging data
into a COALESCE(find(), create(), find()) idiom and ran into a
problem with
Adding the is not null clause does allow the query to use the index again
(and is a much cleaner workaround in that I don't have to change the indexes
or rely on any magic number for splitting the in clauses). Also makes sense
since it more exactly matches the partial indexing condition.
Thanks T
Gerd Koenig wrote:
Since even the init-script starts pg as user postgres I have no idea what
differs from init-script to direct call of pg_ctl as user postgres...?!?!
Do you have SELinux turned on? That can do weird stuff like this--the
init script will be running with restrictions the man
Hi again,
I just want to drop you an additional note. After several attempts of
debugging pg_standby is restoring the WAL files as expected, but I cannot
explain why...
First startup of postgres was with init-script provided by the rpm
installation (/etc/init.d/postgresql start as user root).
On Tue, 2010-08-03 at 22:37 +0200, Gerd Koenig wrote:
> Hello,
>
> we currently setup a standby database with archive_command sending the WALs
> from master to standby.
> This works as expected, but the standby database doesn't restore the WALs
> from
> the given directory in recovery.conf and
On Tue, Aug 3, 2010 at 2:03 PM, Timothy Garnett wrote:
> Hi all,
>
> I'm debugging a performance issue that looks like it might actually be an
> issue/limitation/parameter/bug in the query planner, but since I couldn't
> find anything authoritative on when exactly postgresql is able to use
> parti
Timothy Garnett writes:
> ... My first thought was that there was a problem with the
> statistics/estimation in the planner, but using "set enable seq_scan=off;"
> still does not use the index when there's over 100 bid's in the IN clause.
> Breaking the IN clause into 2 < 100 element groups does h
Hello,
we currently setup a standby database with archive_command sending the WALs
from master to standby.
This works as expected, but the standby database doesn't restore the WALs from
the given directory in recovery.conf and I have no idea why...
recovery.conf:
restore_comman
Hi all,
I'm debugging a performance issue that looks like it might actually be an
issue/limitation/parameter/bug in the query planner, but since I couldn't
find anything authoritative on when exactly postgresql is able to use
partial not null indexes I'm not sure that that's the case and I was hop
On Tue, Aug 3, 2010 at 6:27 AM, Sim Zacks wrote:
>
>> So, about how big is your db? How many users are likely to be running
>> queries at once? How big of a chunk of data are those users likely to
>> each need for sorts etc?
>>
> The database is 400MB (using du on the base folder), I have 10 act
On Tue, Aug 03, 2010 at 03:57:27PM -0400, Tom Lane wrote:
- David Kerr writes:
- > On Tue, Aug 03, 2010 at 03:49:57PM -0400, Tom Lane wrote:
- > - In recent versions of PG, no. Before about 8.3 it was a Really Bad Idea,
- > - because the open transaction would prevent VACUUM from reclaiming stora
David Kerr writes:
> On Tue, Aug 03, 2010 at 03:49:57PM -0400, Tom Lane wrote:
> - In recent versions of PG, no. Before about 8.3 it was a Really Bad Idea,
> - because the open transaction would prevent VACUUM from reclaiming storage.
> We're on 8.3.9, so hopefully it's fairly safe then?
Should
On Tue, Aug 03, 2010 at 03:49:57PM -0400, Tom Lane wrote:
- David Kerr writes:
- > for example: If a java program connects to the DB and does "begin;"
- > and then internally does a "sleep 6 days"
-
- > Does that cauz any issues other than eating a connection to the database?
-
- In recent vers
Thanks a million. Rusty SQL :P
2010/8/3 Merlin Moncure
> 2010/8/3 George Silva :
> > I'm going for Merlin's solution. Its the easiest one :P
> >
> > But I'm also having a problem:
> >
> > SELECT column_name FROM information_schema.key_column_usage k
> > LEFT OUTER JOIN information_schema.tab
David Kerr writes:
> for example: If a java program connects to the DB and does "begin;"
> and then internally does a "sleep 6 days"
> Does that cauz any issues other than eating a connection to the database?
In recent versions of PG, no. Before about 8.3 it was a Really Bad Idea,
because the
2010/8/3 George Silva :
> I'm going for Merlin's solution. Its the easiest one :P
>
> But I'm also having a problem:
>
> SELECT column_name FROM information_schema.key_column_usage k
> LEFT OUTER JOIN information_schema.table_constraints ON (k.table_name =
> table_constraints.table_name)
> WHER
I'm going for Merlin's solution. Its the easiest one :P
But I'm also having a problem:
SELECT column_name FROM information_schema.key_column_usage k
LEFT OUTER JOIN information_schema.table_constraints ON (k.table_name =
table_constraints.table_name)
WHERE
table_constraints.constraint
On Tue, 2010-08-03 at 16:13 -0300, George Silva wrote:
> I'm building a function which needs to know what is the primary key of
> a
> certain table (all in pgplsql).
>
> I was using select * from information_schema.key_column_usage where
> table_schema='foo' and table_name = 'aaa'; but that will g
On Tue, Aug 03, 2010 at 03:30:46PM -0400, Greg Smith wrote:
- David Kerr wrote:
- >I know that "Idle in TXs" can interfere with Vaccums for example, but
- >I'm not sure if that's due to them usually having some form of lock on a
- >table.
- >
-
- Locks aren't the issue. When you have a transact
On Tue, Aug 3, 2010 at 3:13 PM, George Silva wrote:
> Hello guys,
>
> I'm building a function which needs to know what is the primary key of a
> certain table (all in pgplsql).
>
> I was using select * from information_schema.key_column_usage where
> table_schema='foo' and table_name = 'aaa'; but
David Kerr wrote:
I know that "Idle in TXs" can interfere with Vaccums for example, but
I'm not sure if that's due to them usually having some form of lock on a
table.
Locks aren't the issue. When you have a transaction open, the database
makes sure it can deliver a consistent view of the
On 08/03/10 12:13 PM, George Silva wrote:
Hello guys,
I'm building a function which needs to know what is the primary key of
a certain table (all in pgplsql).
I was using select * from information_schema.key_column_usage where
table_schema='foo' and table_name = 'aaa'; but that will give me
On 08/03/10 12:13 PM, David Kerr wrote:
I know that Idle in Transactions are a problem, however I'm trying to
assess how much of a problem.
for example: If a java program connects to the DB and does "begin;"
and then internally does a "sleep 6 days"
Does that cauz any issues other than eating
Hello guys,
I'm building a function which needs to know what is the primary key of a
certain table (all in pgplsql).
I was using select * from information_schema.key_column_usage where
table_schema='foo' and table_name = 'aaa'; but that will give me multiple
results in case of additional keys in
I know that Idle in Transactions are a problem, however I'm trying to
assess how much of a problem.
for example: If a java program connects to the DB and does "begin;"
and then internally does a "sleep 6 days"
Does that cauz any issues other than eating a connection to the database?
(note, not
On Tue, Aug 03, 2010 at 02:01:58PM +0200, Jason Schauberger wrote:
> Dear fellow Postgres users, :-)
>
> please consider this table:
>
> CREATE TABLE nodes (
>
> id int PRIMARY KEY,
>
> parent int REFERENCES nodes(id)
>
> );
Generally, you'll want to separate the nodes table
> -Original Message-
> From: Jason Schauberger [mailto:crossroads0...@googlemail.com]
> Sent: Tuesday, August 03, 2010 8:02 AM
> To: pgsql-general@postgresql.org
> Subject: Nodes and trees...
>
> Dear fellow Postgres users, :-)
>
> please consider this table:
>
> CREATE TABLE nodes (
This example is certainly a workable situation. However it does require
understanding the constraints of an ALTER TABLE statement and manually
developing appropriate scripts.
The update model offered my ChronicDB accounts for schema changes of
considerable complexity, such as merging fields, parti
"Richard" writes:
> 1.To add live HA to PG, I transfer WAL of a database instance(Primary node)
> to another database instance (standby node) at real time, and keep startup
> alive in standby node to recovery WAL online,so that standby node can be a
> hot standby.
> But I got some trouble. Whe
Jeff,
One way to address the indefinite locking due to an ALTER TABLE
statement for PostgreSQL is to use ChronicDB. It allows you to apply
such a schema change live, without bringing down the database.
The space requirements for applying the live schema change would be to
have at least twice as m
1.To add live HA to PG, I transfer WAL of a database instance(Primary node) to
another database instance (standby node) at real time, and keep startup alive
in standby node to recovery WAL online,so that standby node can be a hot
standby.
But I got some trouble. When standby node switch to prim
I uninstalled 8.4 and installed 8.3 with the same results. Any
thoughts? David
On 8/3/2010 11:37 AM, David R Robison wrote:
I ran postgres manually and got some additional information. The full
log is
2010-08-03 15:34:01 GMT DEBUG: 0: postgres: PostmasterMain:
initial environ dump:
20
dev...@gmx-topmail.de writes:
> ist there any possibility for libpq clients to redirect the messages that are
> logged to stderr by libpq e.g. by registering a callback function to handle
> error logging by oneself?
http://www.postgresql.org/docs/8.4/static/libpq-notice-processing.html
Hello Postgres Community,
ist there any possibility for libpq clients to redirect the messages that are
logged to stderr by libpq e.g. by registering a callback function to handle
error logging by oneself?
- Regards
--
GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.
Bis zu 150
I ran postgres manually and got some additional information. The full
log is
2010-08-03 15:34:01 GMT DEBUG: 0: postgres: PostmasterMain: initial
environ dump:
2010-08-03 15:34:01 GMT LOCATION: PostmasterMain,
.\src\backend\postmaster\postmaster.c:736
2010-08-03 15:34:01 GMT DEBUG:
I installed PostgreSQL 8.4 using the one-click installer. However, the
postgres-8.4 windows service will not start. I have checked the Windows
Event Log but there are no entries except one saying that the service
start timed out. I checked the pg_log directory and all that is logged is
2010-0
Hi:
I'm developing a Java application, using Maven, Spring and Hibernate, and
Postgre (with Postgis) as DBMS.
Everything went OK, until I had to import the org.postgresql.util package, to
use the PGobject class, in a UserType Hibernate class.
I got the following errors:
[...]
[loading org/p
On Tue, 2010-08-03 at 16:15 +0200, Ulas Albayrak wrote:
> Hi,
>
> I have a Linux/Debian machine running postgres 8.3 and I need to
> remove a database cluster that I created with the "initdb" command. Is
> it enough to just delete the folder in which the cluster resides on
> the filesystem, or doe
Usually bighouse financial systems use BIGINT and a field to store
position-of-decimal point to track arbitrary precision currency values...
That's the "right way" to do it. I believe for mom-and-pop stuff, you can
satisfy the auditors if you use NUMERIC(,2) and implement round-to-even
(banker's
On Tue, Aug 3, 2010 at 8:01 AM, Jason Schauberger
wrote:
> Dear fellow Postgres users, :-)
>
> please consider this table:
>
> CREATE TABLE nodes (
>
> id int PRIMARY KEY,
>
> parent int REFERENCES nodes(id)
>
> );
>
> In this table, each node *can* have a parent node. You can pic
Dear fellow Postgres users, :-)
please consider this table:
CREATE TABLE nodes (
id int PRIMARY KEY,
parent int REFERENCES nodes(id)
);
In this table, each node *can* have a parent node. You can picture the
whole set of rows of this table as one or more trees with nodes and
t
Hi,
I have a Linux/Debian machine running postgres 8.3 and I need to
remove a database cluster that I created with the "initdb" command. Is
it enough to just delete the folder in which the cluster resides on
the filesystem, or does it require some additional actions?
Regards
--
Ulas Albayrak
ula
> So, about how big is your db? How many users are likely to be running
> queries at once? How big of a chunk of data are those users likely to
> each need for sorts etc?
>
The database is 400MB (using du on the base folder), I have 10 active
users who run queries and functions that generally
2010/8/3 Sim Zacks :
> Is there a way to tell what the optimal memory is for a specific
> postgresql instance?
>
> I am configuring Xen virtual machines and I don't want to give it more
> then it needs.
>
> Would looking at the swap be an indication? As soon as it starts to use
> swap, that means I
In response to Sim Zacks :
>
>
> On 03-Aug-2010 11:18 AM, A. Kretschmer wrote:
> > In response to Sim Zacks :
> >
> >> Is there a way to tell what the optimal memory is for a specific
> >> postgresql instance?
> >>
> >> I am configuring Xen virtual machines and I don't want to give it more
> >
In response to Sim Zacks :
> Is there a way to tell what the optimal memory is for a specific
> postgresql instance?
>
> I am configuring Xen virtual machines and I don't want to give it more
> then it needs.
>
> Would looking at the swap be an indication? As soon as it starts to use
> swap, that
Is there a way to tell what the optimal memory is for a specific
postgresql instance?
I am configuring Xen virtual machines and I don't want to give it more
then it needs.
Would looking at the swap be an indication? As soon as it starts to use
swap, that means I need more, but until that point, I
In response to quickinfo quickinfo :
> Dear all,
>
> I am using postgres. when I try to connect to the database it is showing me
> following error. Please look into that and help me out.
>
> an error occurred:
>
> FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database
> "tem
56 matches
Mail list logo
