[I'll CC the oracle_fdw mailing list where this should be.]
Rob wrote:
> Environment: PostgreSQL 9.1.6
> SLES 11 SP2
> Oracle_fdw 0.9.7
>
> I am trying to implement the use of oracle_fdw.
> So far I have installed an oracle client on my postgres server. I can
> connect to the oracle environment f
Hi All,
We have configured Streaming Replication b/w Primary and Standby server and
Pgpool-II load balancing module diverting SELECT statements to Standby
server. As per our observations, Standby server crashed during peak hours
on today and error message as follows:
2012-10-19 12:26:43 IST [119
ok,
thanks i will look into walbuffers
asynchronous_commit=off is a doubt for responsive environment (pg manual). for
ex.
would it help if,
a game player , has to perform next move on basis of his/her previous move plus
other players move.
all is sent to table and for each player a parti
On 2012-10-15, Daniel Serodio (lists) wrote:
>>
>> OID is optional, IIRC PGXID is not
> I hadn't heard of PGXID, I've just searched Google but found no
> reference to this term except for this e-mail thread and some source
> code. What is PGXID? Where can I learn more about hit?
That was the wr
Hello Arvind,
i worked on MMO (and especially their performance) some time ago. I
really like(d) them. :)
we are all aware of the popular trend of MMO games. where players face
To understand my query, please consider the following scenario
/we store game progress in a postgres table./
A to
Hi,
I'm getting a problem where my application hangs in the process of adding a
field to a table. The app adds the field, then creates an index on the field.
It hangs for ages (minutes) until I cancel the query. My investigation so far
has been
Look at current queries:
agilebasedata=# SELECT
On 19 Oct 2012, at 13:28, Frank Lanitz wrote:
> Just an idea without bigger investigation: Whare are the idle in
> transactions are doing? Maybe they are blocking the create index.
>
> Cheers,
> Frank
Good question, I don't know. The app runs on Java / Apache Tomcat, which
maintains a connecti
Oliver Kohll wrote:
> I'm getting a problem where my application hangs in the process of
adding a field to a table. The app
> adds the field, then creates an index on the field. It hangs for ages
(minutes) until I cancel the
> query. My investigation so far has been
>
> Look at current queries:
>
I have 2 cluster databases, running on the same host, Ubuntu. My fist
database port is set to default but my second database port is set to
5433 in the postgresql.conf file. While everything is ok with local
connections, I cannot connect using any of my tools to the second
database with port 54
On 10/19/2012 07:02 AM, GMAIL wrote:
> I have 2 cluster databases, running on the same host, Ubuntu. My fist
> database port is set to default but my second database port is set to
> 5433 in the postgresql.conf file. While everything is ok with local
> connections, I cannot connect using any of my
Il 19/10/2012 15:24, Chris Ernst ha scritto:
On 10/19/2012 07:02 AM, GMAIL wrote:
I have 2 cluster databases, running on the same host, Ubuntu. My fist
database port is set to default but my second database port is set to
5433 in the postgresql.conf file. While everything is ok with local
connec
On 10/19/2012 07:24 AM, GMAIL wrote:
> Il 19/10/2012 15:24, Chris Ernst ha scritto:
>> On 10/19/2012 07:02 AM, GMAIL wrote:
>>> I have 2 cluster databases, running on the same host, Ubuntu. My fist
>>> database port is set to default but my second database port is set to
>>> 5433 in the postgresql.
Am 2012-10-15 23:13, schrieb John R Pierce:
On 10/15/12 2:03 PM, Daniel Serodio (lists) wrote:
John R Pierce wrote:
On 10/08/12 1:39 PM, Daniel Serodio (lists) wrote:
3) Estimate the size of the transaction log
** We've got no idea how to estimate this, need advice **
postgres doesn't ha
Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
What happens when you try to connect? Any error message? Log entries?
- Chris
now i be able to connect, after update pgAdmin, but i receive the
following error:
"ERROR: column "datconfig" does not exist
LINE 1:
On 10/19/2012 07:50 AM, GMAIL wrote:
> Il 19/10/2012 15:40, Chris Ernst ha scritto:
>> On 10/19/2012 07:24 AM, GMAIL wrote:
>> What happens when you try to connect? Any error message? Log entries?
>> - Chris
> now i be able to connect, after update pgAdmin, but i receive the
> following error:
> "
Il 19/10/2012 16:05, Chris Ernst ha scritto:
On 10/19/2012 07:50 AM, GMAIL wrote:
Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
What happens when you try to connect? Any error message? Log entries?
- Chris
now i be able to connect, after update pgAdmin, but
Oliver Kohll wrote:
>> In the example you show, some connections are "idle in transaction".
>> Such connections can hold locks that block your CREATE INDEX.
>> Could you look at pg_locks if there is a lock that is not granted?
>> There could also be prepared transactions holding locks, if
>> you us
postgresql 9.1 and pgadmin 1.8.4
And there it is. You'll need pgAdmin >= 1.12.x to work with PostgreSQL 9.1.
- Chris
can be a firewall problem?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/m
Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
Il 19/10/2012 15:24, Chris Ernst ha scritto:
On 10/19/2012 07:02 AM, GMAIL wrote:
I have 2 cluster databases, running on the same host, Ubuntu. My fist
database port is set to default but my second database port
Il 19/10/2012 16:11, Shaun Thomas ha scritto:
On 10/19/2012 09:06 AM, GMAIL wrote:
i use postgresql 9.1 and pgadmin 1.8.4
Yeah, that version of pgAdmin is *way* too old. 1.16 was released
fairly recently, and it works great.
i try the version 1.16 but it doesn't work. i don't get any erro
Hey!
I'm currently in the situation that due to (probably) broken memory in
a server, I have a corrupted PostgreSQL database. Getting at the data
that's in the DB is not time-critical (because backups have restored the
largest part of it), but I'd still like to restore what can be restored
fr
Il 19/10/2012 16:33, Shaun Thomas ha scritto:
If you don't get any error message from the client or the server, are
you sure it didn't work?
I only ask because 1.8 was so old, I'm surprised it even worked with
the version you had before. The catalog has changed a lot since then,
and the err
Arvind Singh wrote:
>
> ok,
>
> thanks i will look into walbuffers
>
> asynchronous_commit=off is a doubt for responsive environment (pg manual).
> for ex.
>
> would it help if,
>
> a game player , has to perform next move on basis of his/her previous move
> plus other players move.
> al
Il 19/10/2012 16:55, Shaun Thomas ha scritto:
Yep. You've got a firewall between you and your server. Somewhere.
Good luck tracking that down, sir. Everything should clear up when/if
that gets resolved.
i think that the problem should be the service iptables.
what i have to change if i want to
On 10/19/2012 08:06 AM, GMAIL wrote:
> Il 19/10/2012 16:05, Chris Ernst ha scritto:
>> On 10/19/2012 07:50 AM, GMAIL wrote:
>>> Il 19/10/2012 15:40, Chris Ernst ha scritto:
On 10/19/2012 07:24 AM, GMAIL wrote:
What happens when you try to connect? Any error message? Log entries?
- Ch
Thanks Laurenz for your post...
Some more info
Oracle Server:Oracle 11g R2 (11.2.0.2.0)
Client: 11.2
Was installed using Oracle Universal Installer
I don't really want to post the full environment of the postmaster but
basically I could see no entry in there for ORACLE_HOME or TNS_ADMIN, should
On 10/19/2012 09:06 AM, GMAIL wrote:
i use postgresql 9.1 and pgadmin 1.8.4
Yeah, that version of pgAdmin is *way* too old. 1.16 was released fairly
recently, and it works great.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
stho...@options
Il 19/10/2012 16:45, Shaun Thomas ha scritto:
On 10/19/2012 09:38 AM, GMAIL wrote:
but if i connect from another pc, with pgadmin 1.16 or other software,
to the host with postgresql i get a "connection refused" message
Ok. That narrows it down slightly. If you check your PG logs for FATAL
me
On 10/19/2012 09:14 AM, GMAIL wrote:
i try the version 1.16 but it doesn't work. i don't get any error
message
If you don't get any error message from the client or the server, are
you sure it didn't work?
I only ask because 1.8 was so old, I'm surprised it even worked with the
version you
On 10/19/2012 09:59 AM, GMAIL wrote:
i think that the problem should be the service iptables.
what i have to change if i want to accept all request to the port 5433?
iptables only affects the machine your server is running on. There can
be a firewall literally *anywhere* between your client a
On 19 Oct 2012, at 15:09, "Albe Laurenz" wrote:
> You should always include the list in your replies -
> other people might be interested in the solution.
Oops, thought I had.
>
> There must be at least two transactions involved
> to create a locking problem like you describe.
> But since CRE
On 19/10/2012 15:38, GMAIL wrote:
> Il 19/10/2012 16:33, Shaun Thomas ha scritto:
>>
>> If you don't get any error message from the client or the server, are
>> you sure it didn't work?
>>
>> I only ask because 1.8 was so old, I'm surprised it even worked with
>> the version you had before. The cat
On 10/19/2012 09:52 AM, GMAIL wrote:
using ping i receive a connection timed out
Yep. You've got a firewall between you and your server. Somewhere. Good
luck tracking that down, sir. Everything should clear up when/if that
gets resolved.
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd.
On 10/19/2012 09:38 AM, GMAIL wrote:
but if i connect from another pc, with pgadmin 1.16 or other software,
to the host with postgresql i get a "connection refused" message
Ok. That narrows it down slightly. If you check your PG logs for FATAL
messages, and you don't see anything complaining
Hi all,
trying to run pgwatch1.0 on Ubuntu 12.04 through a Bitnami LAPPstack.
# select version();
PostgreSQL 9.1.1 on i686-pc-linux-gnu, compiled by gcc (GCC) 3.2.2
20030222 (Red Hat Linux 3.2.2-5), 32-bit
Pgwatch installation finishes OK but the webpages of pgwatch display nothing.
Overview: ha
35 matches
Mail list logo
