Hi all,
I’ve just noticed that some DDL statements will block if there are other
queries accessing the relation in question, even where those queries are not
dependant on the underlying structures (such as a new index, created after
the initial query).
For instance…
SELECT long_running_query
Hi,
I have a local db behind a firewall etc. Basically, I'd like to do what
I'd locally would...
create table abc
as
select
*
from
local_expensive_view;
abc - on RDS
local_expensive_view - on local machine
How would you go about doing this?
Thanks,
Marcus
--
Sent via
Tim Kane tim.k...@gmail.com writes:
[ DROP INDEX requires exclusive lock on index's table ]
Is this behaviour by design?
Yes. Even if you assumed that the DROP had complete information about
all concurrent queries (which it does not, and we could not cheaply
provide that), it would still be
Hello.
I was running PostgreSQL 9.1.4 when I got a server process crash
(Segmentation fault) as the postgres log shown below. I tried upgrade to newest
version 9.3.4, but this gives exactly the same problem.
It is an (ecpg based) C-program that does tons of these scroll cursor
On 05/06/2014 07:08 AM, Leif Jensen wrote:
Hello.
I was running PostgreSQL 9.1.4 when I got a server process crash
(Segmentation fault) as the postgres log shown below. I tried upgrade to newest
version 9.3.4, but this gives exactly the same problem.
It is an (ecpg based)
On Tue, May 6, 2014 at 5:52 AM, Marcus Engene meng...@engene.se wrote:
Hi,
I have a local db behind a firewall etc. Basically, I'd like to do what
I'd locally would...
create table abc
as
select
*
from
local_expensive_view;
abc - on RDS
local_expensive_view - on local
On 06/05/14 16:58, bricklen wrote:
A very quick search shows that rds supports dblink, so perhaps that
would work.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html
Then I'd need to open our servers to external visits. It would be lovely
if dblink_exec could push a
On Tue, May 6, 2014 at 8:07 AM, Marcus Engene meng...@engene.se wrote:
On 06/05/14 16:58, bricklen wrote:
A very quick search shows that rds supports dblink, so perhaps that would
work.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/
CHAP_PostgreSQL.html
Then I'd need to open our
On 06/05/14 17:15, bricklen wrote:
On Tue, May 6, 2014 at 8:07 AM, Marcus Engene meng...@engene.se
mailto:meng...@engene.se wrote:
On 06/05/14 16:58, bricklen wrote:
A very quick search shows that rds supports dblink, so perhaps
that would work.
A very quick search shows that rds supports dblink
Then I'd need to open our servers to external visits.
This is sort of getting away from Postgres, but if the RDS instance is
in a VPC, you could put a VPN on the VPC so dblink wouldn't have to go
over the open Internet.
Paul
On Tue, May 6,
Hi all,
I’ve just noticed that some DDL statements will block if there are other
queries accessing the relation in question, even where those queries are not
dependant on the underlying structures.
For instance…
SELECT long_running_query FROM foo; -- Query A,
-- meanwhile…
CREATE UNIQUE
Hello,
Is there a depot available for 11.23? I have the source for PostgreSQL 9.03
and am trying to just get the ODBC shared library to compile but I am have
several issues; so, a deport would be great.
Thank you,
Steve Wilkins
Software Engineer III
EVRAZ INC. NA
Phone: (503) 978-6144
On 05/06/2014 07:07 AM, Steve Wilkins wrote:
Hello,
Is there a depot available for 11.23? I have the source for PostgreSQL
9.03 and am trying to just get the ODBC shared library to compile but I
am have several issues; so, a deport would be great.
The only one I could find is for Postgres
So, I am trying to import a file into a table and want to assign a sequence
value to each record as it is imported.
I know that I can pre-process the input file and simply add the needed data
but I am curious if maybe there is some trick to having defaults populate
for missing columns WITHOUT
On Tue, May 05/06/14, 2014 at 01:22:20PM -0700, David G Johnston wrote:
So, I am trying to import a file into a table and want to assign a sequence
value to each record as it is imported.
I know that I can pre-process the input file and simply add the needed data
but I am curious if maybe
On 5/6/2014 1:22 PM, David G Johnston wrote:
I know that I can pre-process the input file and simply add the needed data
but I am curious if maybe there is some trick to having defaults populate
for missing columns WITHOUT explicitly specifying each and every column that
is present?
if you
On Tue, May 6, 2014 at 4:48 PM, John R Pierce [via PostgreSQL]
ml-node+s1045698n5802802...@n5.nabble.com wrote:
On 5/6/2014 1:22 PM, David G Johnston wrote:
I know that I can pre-process the input file and simply add the needed
data
but I am curious if maybe there is some trick to having
On 7/05/2014, at 3:07 am, pgsql-general-ow...@postgresql.org wrote:
I would just use check_postgres (perl) from your agent script...
Having downloaded and had a look at this script I would agree. I'll let
check_postgresl do the heavy lifting and just try and get a build an MP that
collects
Thanks Tom, I see there are a lot of considerations. I guess I just found it
to be an interesting scenario, although not entirely unexpected. It’s not a
big deal of course.
Cheers,
Tim
From: Tom Lane t...@sss.pgh.pa.us
Date: Tuesday, 6 May 2014 15:05
To: Tim Kane tim.k...@gmail.com
Cc:
Hi,
I need to setup a replication process for continuously replicating changes
happening in an Oracle Database to a PostgreSQL database.
My Oracle Database is version 11.2 and setup as a cluster with RAC
My Postgres database version is 9.2
Oracle Database is running in Solaris and PostgreSQL
20 matches
Mail list logo