Re: [GENERAL] Server process crash - Segmentation fault

Hello Adrian, Thank you for your answer. I can post part of the code that makes these calls, but I'm not sure how much it would help. It is rather large function that makes these calls, and it is called all over the program. The part of the log posted is only a small excerpt of the use of

[GENERAL] ERROR: permission denied for database control

Hi, I've encountered a weird problem in PostgreSQL : postgres=> create user test password 'test'; postgres=> grant select on pg_catalog.pg_database_size to test; postgres=> grant execute on function pg_catalog.pg_database_size(name) to test; --login as user test postgres=> select current_user;

[GENERAL] Oracle to PostgreSQL replication

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 i

Re: [GENERAL] DDL statement blocked on long-running query with no runtime dependancy

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 Date: Tuesday, 6 May 2014 15:05 To: Tim Kane Cc: pgsql-general General Subject: Re: [G

Re: [GENERAL] Monitoring Pg servers with Microsoft SCOM

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

[GENERAL] Re: any psql \copy tricks for default-value columns without source data?

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 h

Re: [GENERAL] any psql \copy tricks for default-value columns without source data?

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 didn

Re: [GENERAL] any psql \copy tricks for default-value columns without source data?

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

[GENERAL] any psql \copy tricks for default-value columns without source data?

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 expl

Re: [GENERAL] HP-UX 11.23

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 9.

[GENERAL] HP-UX 11.23

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 Fax:

[GENERAL] DDL statement blocked on long-running query with no runtime dependancy

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

Re: [GENERAL] copy expensive local view to an RDS instance

>> 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,

Re: [GENERAL] copy expensive local view to an RDS instance

On 06/05/14 17:15, bricklen wrote: On Tue, May 6, 2014 at 8:07 AM, Marcus Engene > 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/AmazonR

Re: [GENERAL] copy expensive local view to an RDS instance

On Tue, May 6, 2014 at 8:07 AM, Marcus Engene 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 s

Re: [GENERAL] copy expensive local view to an RDS instance

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

Re: [GENERAL] copy expensive local view to an RDS instance

On Tue, May 6, 2014 at 5:52 AM, Marcus Engene 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 machine >

Re: [GENERAL] Server process crash - Segmentation fault

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) C-progra

[GENERAL] Server process crash - Segmentation fault

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 exercis

Re: [GENERAL] DDL statement blocked on long-running query with no runtime dependancy

Tim Kane 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 possible for an in

[GENERAL] copy expensive local view to an RDS instance

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 pgsql-genera

[GENERAL] DDL statement blocked on long-running query with no runtime dependancy

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 F