[GENERAL] What kinds of simple expressions need a snapshot?

Hi, I'm reading code in plpgsql, and I notice that exec_eval_simple_expr() will get a snapshot for the expr if it is in a VOLATILE function. Then I try to find out why a snapshot is needed for a expr which has passed exec_simple_check_plan(). The only reason I could figure out is that maybe VOLA

[GENERAL] Is it possible that session lock is not released

Hi, I just found that ShutdownPostgres() only releases USER_LOCKMETHOD locks, so why not release DEFAULT_LOCKMETHOD locks? Check if this is possible: We are doing a CREATE INDEX CONCURRENTLY, and codes runs to LockRelationIdForSession(&heaprelid, ShareUpdateExclusiveLock); PopAct

[GENERAL]

hi all, I am using postgres 9.4 on windows 7. i want import that backup sql file into postgres schema. i googled i got copy, but when i ran in windows COPY actor FROM 'c:\users\venu\downloads\sakila-data.sql'; ERROR: invalid input syntax for integer: "" CONTEXT: COPY actor, line 1,

[GENERAL] xml

Hi all, SELECT xmlagg(xmlelement( name actor, xmlattributes(first_name) )ORDER BY actor_id,',')from actor; the above code return following result, [image: Inline image 1] Question : i want retrieve result from above XML result like

Re: [GENERAL] stack builder

Hi, I had installed pgadmin3 but not selected stackbuilder ,let me know how to add stackbuilder to pgadmin3 for additional addons. On Wed, Apr 1, 2015 at 7:15 PM, Adrian Klaver wrote: > On 04/01/2015 06:22 AM, Ramesh T wrote: > >> Hi all, >>

[GENERAL] stack builder

Hi all, I didn't selected stack builder at the time of installation of postgres.Any help how to add* application stack builder* to existed postgres.

Re: [GENERAL] stack builder

I had installed on Linux.re-install postgres for stack builder ..? cron is their ,but I am new to this cron and is this method for job schedulers in postgres. On Wed, Apr 1, 2015 at 8:39 PM, Adrian Klaver wrote: > On 04/01/2015 07:59 AM, Ramesh T wrote: > >>Hi, >>

[GENERAL]

Hi , How to create job in pgAgent.Where I need to place script in pgAgent..any help Advanced thanks...

Re: [GENERAL]

nd-schedules-programatically-with-pgagent > > regards > > Pavel Stehule > > 2015-04-03 11:27 GMT+02:00 Ramesh T : > >> Hi , >> How to create job in pgAgent.Where I need to place script in >> pgAgent..any help >> >> Advanced thanks... >> >> >

Re: [GENERAL] Stalled post to pgsql-general

..? On Fri, Apr 3, 2015 at 3:50 PM, wrote: > Your message to pgsql-general has been delayed, and requires the approval > of the moderators, for the following reason(s): > > The author (Ramesh T ) > is not a member of any of the restrict_post groups. > > If you do not wish t

Re: [GENERAL] Pgagent

7;m running function on particular database and selected today dates.. but function wasn't executed. let me know how to set it function in pgagent.. On Mon, Apr 13, 2015 at 7:26 PM, Adrian Klaver wrote: > On 04/13/2015 06:53 AM, Ramesh T wrote: > >> Hi all, >> i h

[GENERAL] Pgagent

Hi all, i have a function to delete data from table.Where i need to place function in pgagent.in definition section can i select SQL or BATCH ..? or else any other method.? Any Help..

Re: [GENERAL] Pgagent

ian Klaver wrote: > On 04/13/2015 07:22 AM, Ramesh T wrote: > >> Hi, >> in steps>definition-> >> do >> $body$ >> begin >> perform delete_empty_parts(); >> end; >> $body$ >> >> delete_empty_parts is the function >> >&

[GENERAL]

Hi all, as i mentioned above i have function called delete parts can i mention select deleteparts(); or c:\programfiles\9.4\pgagent\check.sql in this path check.sql contain to delete parts.i placed query select deleteparts(); when click run now job,it returns statistics failed and etc/

[GENERAL] Functions

Hi All, I want move functions from onedatabase to other database in same host on windows 7 and installed postgres version is 9.4.I'm using pgadmin3 tool. any help..?

Re: [GENERAL] Functions

thank you it's helpfull On Fri, May 8, 2015 at 7:43 PM, Adrian Klaver wrote: > On 05/08/2015 01:56 AM, Ramesh T wrote: > >> Hi All, >>I want move functions from onedatabase to other database in same host >> on windows 7 and installed postgres version is 9

[GENERAL] regexp_matches for digit

Hi, in oracle regexp_like(entered date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i') for postgres i have regexp_matches ,But i need how to match [:digit:] in postgres when we pass date..? any help

Re: [GENERAL] regexp_matches for digit

nice i'm looking for this,i thought digit don't work in postgres.. thanks On Thu, Jul 9, 2015 at 10:21 PM, Chris Mair wrote: > > Hi, > > in oracle regexp_like(entered > > date,'[[:digit:]]{4}-[[:digit:]]{2}-[[:digit:]]{2}','i') > > > > for postgres i have regexp_matches ,But i need how

[GENERAL] xmltable in postgres like in oracle..?

Hi, is xmltable available in postgres..?,if not please give me a advice to replace the xmtable in postgres..?

[GENERAL] timestamp check

select current_timestamp-to_timestamp(to_char(current_date,'-MM-DD HH24'||':'||'MI'||':'||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name='US/Eastern'),'-MM-DD HH24'||':'||'MI'||':'||'SS')::timestamptz; it's not displaying timezone..any help..?

Re: [GENERAL] timestamp check

gres query..i thnk something wrong. is it..? any help apprictiated. On Sat, Jul 11, 2015 at 11:12 PM, Adrian Klaver wrote: > On 07/10/2015 05:54 AM, Ramesh T wrote: > >> >> select current_timestamp-to_timestamp(to_char(current_date,'-MM-DD >> HH24'||'

Re: [GENERAL] timestamp check

okay,i'm executing a query from pgadmin3. i want display time with timezone.But above query displaying date and time not timezone... On Sat, Jul 11, 2015 at 9:34 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T > wrot

Re: [GENERAL] xmltable in postgres like in oracle..?

xml table is the oracle function ..thank you sir On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver wrote: > On 07/11/2015 08:32 AM, Ramesh T wrote: > >> Hi, >>is xmltable available in postgres..?,if not please give me a >> advice to replace the xmtable in po

Re: [GENERAL] timestamp check

any help..? On Sun, Jul 12, 2015 at 11:51 AM, Ramesh T wrote: > postgres query > select current_timestamp- > TO_TIMESTAMP(to_char(DATE1, '-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' > '||(SELECT utc_offset FROM pg_cat

Re: [GENERAL] xmltable in postgres like in oracle..?

y row from temp table? On Sun, Jul 12, 2015 at 5:38 PM, Ramesh T wrote: > xml table is the oracle function ..thank you sir > > On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver > wrote: > >> On 07/11/2015 08:32 AM, Ramesh T wrote: >> >>> Hi, >>>

Re: [GENERAL] xmltable in postgres like in oracle..?

i got function select regexp_split_to_table('2,1', E',')::bigint thanks On Mon, Jul 13, 2015 at 4:13 PM, Ramesh T wrote: > WITH idtable AS ( > SELECT '2342,8766' id > ) > > select * from inv where id in( > SELECT id > FROM idtable) &g

Re: [GENERAL] timestamp check

Yes,But i need to display last digits also [image: Inline image 1] like 1500 08-09-10.738901 On Mon, Jul 13, 2015 at 8:18 PM, Francisco Olarte wrote: > Hi Ramesh: > > On Sun, Jul 12, 2015 at 8:21 AM, Ramesh T > wrote: > >> postgres query >> select current_timesta

Re: [GENERAL] timestamp check

,'-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names WHERE name=changed_dttimezone), '-MM-DD HH24'||' '||'MI'||' '||'SS')::timestampt

[GENERAL] Postgres Recovery

Hi All, What i need to know for postgres recovery..?let me know in detail.

Re: [GENERAL] Postgres Recovery

it from server commmand mean from putty is it possible..? i want commands to execute the set to the server without open the postgres.conf...? On Mon, Jul 20, 2015 at 6:23 PM, Michael Paquier wrote: > On Mon, Jul 20, 2015 at 7:00 PM, Ramesh T > wrote: > > Hi All, > > W

[GENERAL] instr detail

Hi All, is instr available in postgres 9.3..? in oracle instr('12.32.42','.',-1) ,any help appreciated

Re: [GENERAL] instr detail

select position('.' in '.T.homas') result 1 it returns first postion.but I need last occurence of ' . ' . actual result -- 3 any help..?appreciated. On Thu, Jul 30, 2015 at 5:00 AM, Tom Lane wrote: > Melvin Davidson writes: > > Based om the definition of Oracle instr(), the equiva

Re: [GENERAL] instr detail

here is the example tks help.. http://stackoverflow.com/questions/2965655/how-to-find-the-first-and-last-occurrences-of-a-specific-character-inside-a-stri On Thu, Jul 30, 2015 at 7:38 PM, Ramesh T wrote: > select position('.' in '.T.homas') > result > >

[GENERAL] postgres 9.3

I changed archive_command in postgresql.conf and restarted it.postgres 3 installed on linux.connected from putty. after restarted it getting message like -bash-4.1$ service postgres-9.3 start postgres-9.3: unrecognized service but files available at server side.. any help..?

[GENERAL] pghba.conf

Hi All, I changed in pg_hba.conf like,in postgres 9.3 under linux host replication base_backup_user 127.0.0.1/32 trust after above changes ,restarted it . when i try pgbasebackp getting error like, pg_basebackup: could not connect to server: FATAL: no pg_hba.conf en

[GENERAL] postgres connection

Hi all, I got a problem when i start postgres server. like' could not connect to the server: connection refused on host 2.3.421.1 and accepting tcp/ip connection on port 5432. any help appreciated..

Re: [GENERAL] postgres connection

any help On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T wrote: > Hi all, > I got a problem when i start postgres server. > like' >could not connect to the server: connection refused on host > 2.3.421.1 and accepting tcp/ip connection on port 5432. > > any help appreciated.. >

Re: [GENERAL] postgres connection

on on port 5432. any help to start server.. On Fri, Aug 7, 2015 at 2:26 PM, Ramesh T wrote: > any help > > On Thu, Aug 6, 2015 at 6:51 PM, Ramesh T > wrote: > >> Hi all, >> I got a problem when i start postgres server. >> like' >&g

[GENERAL] view

HI , I have view .when i try to select view ,it had return select * from art; ERROR: permission denied for relation sub_item SQL state: 42501

[GENERAL] Import Problem

Hi All, I'm using or2pg tool ,I exported data but I have to change the schema import to postgres database.exported data more than gb. Can you please let me know, how to do the change the name in data script..?

Re: [GENERAL] Import Problem

right.manullay is not possible change name of schema in qa is have 2 gb data when i try to change name of the data scipt is hanged. On Thu, Sep 17, 2015 at 11:54 AM, Venkata Balaji N wrote: > > On Thu, Sep 17, 2015 at 1:27 AM, Ramesh T > wrote: > >> Hi All, >>

Re: [GENERAL] Import Problem

with out hanging how to open data script of the oracle schema to change the name. On Thu, Sep 17, 2015 at 6:31 PM, Ramesh T wrote: > Actually ,oracle have the *qa *schema i have to import to this schema to > postgres database.But in postgres database already have the *qa *schema.My >

[GENERAL] postgres 9.3

I have one database and two schemas in that public,preview and role preview automatically i want to connect preview schema with preview role. set search_path to preview. show search_path; .. preview. when disconnect and connect database it's showing $user$:public schema not showing preview. wha

[GENERAL] pgcrypto

Hi, i created extension pgcrypto on public with postgres user.But while trying to use from my own schma suppose qa. when i run digest in function in my qa CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$ SELECT encode(digest($1, 'sha1'), 'hex') $$ LANGUAGE SQL STRICT

[GENERAL] to pg

CREATE UNIQUE INDEX idx_load_pick ON pick (case picked when picked='y' then load_id else null end ); how can i convert case expressed to postgres..above it is oracle. any help appreciated...

[GENERAL] Format

Hi All, How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres. any help appreciated..

Re: [GENERAL] Format

On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T wrote: > in my mind to be beautiful ,avoid confusion to understand sql query code > > like > > select abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ; > > if some one written, then newer or code reader understand

Re: [GENERAL] Format

Nice, thank you. On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver wrote: > On 09/29/2015 06:13 AM, Ramesh T wrote: > >> >> >> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T > <mailto:rameshparnandit...@gmail.com>> wrote: >> >> in my mind to be be

[GENERAL] postgres function

Hi All, Do we have function like regexp_substr in postgres..? in oracle this function seach the - from 1 to 2 and return result, regexp_substr(PART_CATG_DESC,'[^-]+', 1, 2)

Re: [GENERAL] postgres function

end with - i.e , i need to find second postition of the variable between the '-' On Thu, Oct 15, 2015 at 6:32 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Oct 15, 2015 at 8:32 AM, Ramesh T > wrote: > >> select position('-' in &#

Re: [GENERAL] postgres function

select position('-' in '123-987-123') position --- 4 But I want second occurrence, position - 8 plz any help..? On Thu, Oct 15, 2015 at 12:54 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Oct 14, 2015 at 9:38 AM, R

Re: [GENERAL] postgres function

;-',4) >0 then 1 else 0 end it's return error like integer need... On Thu, Oct 15, 2015 at 8:50 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Oct 15, 2015 at 10:05 AM, Ramesh T > wrote: > >> '123-987-123' it is not fixed some t

[GENERAL] Taking lot time

I have a Query it taking a lot of time to fetch results so,explain query gave "Hash Join (cost=55078.00..202405.95 rows=728275 width=418)" " Hash Cond: (itd.tran_id = iad._adj__id)" " -> Seq Scan on inv_detail itd (cost=0.00..40784.18 rows=731029 width=95)" "Filter: (event_type = ANY

[GENERAL] upsert with trigger (or rule)

Hello, I’m trying to rewrite inserts to upserts on a table when a certain column has a certain value. Reason: the inserts are coming from an ORM. It’s possible to send upsert from the ORM, however, in this case I find it more elegant and future-proof to deal with it at the DB level

Re: [GENERAL] upsert with trigger (or rule)

Hello Adrian, On 19/07/16 21:27, Adrian Klaver wrote: On 07/19/2016 11:56 AM, Maeldron T. wrote: By returning NULL in your function you are skipping the original INSERT. I know that, I wrote it. I am sure exactly what you are trying to achieve, In general, there are the

Re: [GENERAL] upsert with trigger (or rule)

On 19/07/16 23:45, Adrian Klaver wrote: To be more complete it would nice to see the schema definition for the table messages. Also maybe some idea of what you the code is supposed to do. If I understand it correctly: 1) Check if a message is a draft. 2) Check if there is a uniqueness con

Re: [GENERAL] Uber migrated from Postgres to MySQL

On 26/07/16 19:39, Guyren Howe wrote: Honestly, I've never heard of anyone doing that. But it sounds like they had good reasons. https://eng.uber.com/mysql-migration/ Thoughts? 1. Open the page 2. Press Cmd-F on Mac, Ctrl-F on Linux/Windows. (Find on page) 3. Type "transaction" in the sear

[GENERAL] Google Cloud Compute

Hello, I’m considering moving my servers to Google. The main reason is the transparent encryption they offer. This means I should either move all or none. The former would include PostreSQL, specifially: FreeBSD + ZFS + PostgreSQL. Do you have any pros or cons based on experience? (Would fsy

[GENERAL] FreeBSD 10 => 11: Dump and reload your PostgreSQL database unless you like it broken

Hello, I’ll be as short as I can as I have broken my arm and I’m not supposed to type. This isn’t a joke. However, I learned the following the hard way and I want to save you from the same. Upgrading FreeBSD from 10 to 11 might break your database. It probably won’t be corrupted but it will be u

[GENERAL] Re: FreeBSD 10 => 11: Dump and reload your PostgreSQL database unless you like it broken

I forgot to add that when I turned off index scan, select lower() still didn’t find some existing rows. On Sat, Dec 3, 2016 at 2:52 AM, Maeldron T. wrote: > Hello, > > I’ll be as short as I can as I have broken my arm and I’m not supposed to > type. This isn’t a joke. > > Howe

Re: [GENERAL] FreeBSD 10 => 11: Dump and reload your PostgreSQL database unless you like it broken

Hello Thomas, > > (Maybe database clusters should have a header that wouldn’t allow > > incompatible server versions to process the existing data. I wonder if it > > would take more than 8 bytes per server. But I guess it was not know to > be > > incompatible. Even my two CIs didn’t show it.) > >

Re: [GENERAL] Taking lot time

the query is big it's selecting 20 rows from two table like i mentioned above exaplain analyze what should i do..?any help On Wed, Nov 4, 2015 at 4:27 AM, Adrian Klaver wrote: > On 11/03/2015 06:42 AM, Ramesh T wrote: > >> I have a Query it taking a lot of time to fetch resu

Re: [GENERAL] Taking lot time

random_page_cost = 5.0 effective_cache_size = 1024MB On Wed, Nov 18, 2015 at 11:12 PM, Adrian Klaver wrote: > On 11/17/2015 04:18 AM, Ramesh T wrote: > >> the query is big it's selecting 20 rows from two table like i mentioned >> above exaplain analyze >> >> what shou

Re: [GENERAL] Taking lot time

appreactiated ! On Thu, Nov 26, 2015 at 12:04 AM, Adrian Klaver wrote: > On 11/25/2015 07:46 AM, Ramesh T wrote: > > First, please take a look at this: > > https://en.wikipedia.org/wiki/Posting_style > > >> Hi All, >> 9.3 version using pgadmin3 >> >> Que

[GENERAL] BSD initdb without ICU support and switch later

Hello, the ICU patch isn’t ready for PostgreSQL on FreeBSD. Is there any risk (more than 0) in executing the initdb without ICU support and recompiling PostgreSQL later when the ICU patch is ready? I mean any risk without making a dump and import before the switch. If this is okay for su

Re: [GENERAL] Why facebook used mysql ?

On Sun, Nov 14, 2010 at 12:15 PM, Ron Mayer wrote: > Lincoln Yeoh wrote: > > What's more important to such companies is the ability to scale over > > multiple machines. > > That question - how much work it is to administer thousands of database > servers - seems to have been largely missing from t

[GENERAL] BAKUP ISSUE

HI, I have a problem when i take backup using pg_basebackup and pg_start_backup('base'); following , 1) select pg_start_backup('base'); pg_start_backup 0/1628 2) postgres=# select pg_stop_backup(); NOTICE: pg_stop_backup cleanup done, waiting for required WAL

Re: [GENERAL] BAKUP ISSUE

Jul 9, 2014 at 6:23 PM, hubert depesz lubaczewski wrote: > Hi, > > First - do not take the messages off list. Someone else might be able to > help you if you'll mail to the list, I'm not always there, and others might > have better ideas. > > > On Wed, Jul 9, 2014 a

[GENERAL] performance monitoring/tuning

Hi, How performance monitoring/tuning on postgres..? please let me know some links to learn, ex-query performence, i need it .. thanks in advance, ramesh

[GENERAL] cursor return null

Hello, in postgres function (id bigint ),the following code not return any value with artNums ,But when i do select statement ony it's output the values with out include cursor i.e,cursor problem ..? please let me know what should i do to getvalues from cursor, but i dont where i mis

[GENERAL] Need r_constraint_name

Hi, In oracle got constraint details using user_constraint, But in postgres how to get the r_constraint_name,constraint_name of the particular table...? mainly i need r_constraint_name on table.. how to get it?please let me know

Re: [GENERAL] Need r_constraint_name

e as above .. but i want check "r_constraint_name" instead of "constraint_name" in outer statement in above code.. please let me know.. thanks in advance, ramesh On Tue, Jul 22, 2014 at 7:52 AM, Adrian Klaver wrote: > On 07/19/2014 12:26 PM, Ramesh T wrote: >

Fwd: [GENERAL] Need r_constraint_name

-- Forwarded message -- From: Ramesh T Date: Tue, Jul 22, 2014 at 7:50 PM Subject: Re: [GENERAL] Need r_constraint_name To: Adrian Klaver Just i'm retriving the constraint_name when i enter child_table_name for inner query and that constraint name is checking parent_tab

[GENERAL] tab_to_sting

Hi, SELECT hr.tab_to_largestring(CAST(COLLECT(cust_name) AS t_varchar2_tab)) AS employees FROM hr.customer when i run function for table column values to single row function name is hr.tab_to_largestring this code from oracle it return like function collect(character varying)

Re: [GENERAL] tab_to_sting

.? i need this one please let me know.. thanks in advance , ramesh On Thu, Jul 24, 2014 at 2:11 AM, Adrian Klaver wrote: > On 07/23/2014 09:12 AM, Ramesh T wrote: > >> Hi, >> >> SELECT hr.tab_to_largestring(CAST(COLLECT(cust_name) AS >> t_varchar2_tab))

Re: [GENERAL] tab_to_sting

SELECT qa.tab_to_largestringcheck(cast(array_agg(part_id)as t_varchar2_tab),':')FROM qa.part when i replace string_agg it's return does not exit, need to enable string_agg ..?i think is predefined right On Thu, Jul 24, 2014 at 7:47 PM, Ramesh T wrote: > postgres 9.3 &g

Re: [GENERAL] tab_to_sting

.3 thanks in advance, ramesh On Thu, Jul 24, 2014 at 6:24 PM, Ramesh T wrote: > > CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); > / > > CREATE OR REPLACE FUNCTION tab_to_string (p_varchar2_tab IN > t_varchar2_tab, >

Re: [GENERAL] tab_to_sting

i need it please let me know thanks in advance, On Thu, Jul 24, 2014 at 7:26 PM, Adrian Klaver wrote: > On 07/24/2014 05:54 AM, Ramesh T wrote: > >> >> CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); >> / >> >> CREATE OR REPLACE

Re: [GENERAL] tab_to_sting

need to add explicit type casts. On Thu, Jul 24, 2014 at 8:00 PM, Adrian Klaver wrote: > On 07/24/2014 07:22 AM, Ramesh T wrote: > >> SELECT >> qa.tab_to_largestringcheck(cast(array_agg(part_id)as >> t_varchar2_tab),':')FROM qa.part >> >> when

Re: [GENERAL] tab_to_sting

need to add explicit type casts. i thought string_agg and array_agg same, is it right..? On Thu, Jul 24, 2014 at 8:19 PM, Adrian Klaver wrote: > On 07/24/2014 07:46 AM, Ramesh T wrote: > >> i ran the \df string_agg is their >> >> but retuns like >> ERROR: fun

Re: [GENERAL] tab_to_sting

ringcheck(string_agg(part_id::text,':')) FROM qa.part its returnfunction( text)does'nt exist let me know how solve issue.. thanks, On Thu, Jul 24, 2014 at 10:42 PM, Adrian Klaver wrote: > On 07/24/2014 08:03 AM, Ramesh T wrote: > >> I have try >> select strin

[GENERAL] TZ_OFFSET

Hello, select TZ_OFFSET ('US/Eastern') from dual ; it's returning in oracle -- -04:00 but in postgres select TZ_OFFSET ('US/Eastern'); its'returning like function tz_offset('us/Eastern') does not exist; let me know how to solve issue

[GENERAL] Postgres Performence

Hello, How to improve performence of postgres 9.3 database.And also in oracle web based Enterprise manger is available,in postgres any tool their to monitor and change. please let me know performence related info to my postgres 9.3 database.and any tools which are free and pay. thanks,

[GENERAL] {xml}

Hello, when i ran following query on postgres 9.3, SELECT xmlagg(xmlelement(name e,part_id||',')) from part; result .. {xml} how to get part_id's..? please let me know .. advance thanks, R..

[GENERAL] pgcluu

Hi, i want install pgcluu on postgres 9.3 and i'm putty tool to connect pg database when i ran . tar xzf pgcluu-2.0.tar.gz cd pgcluu-2.0.tar/ perl Makefile.PL make && sudo make install it's return like.. bash-4.1$ tar xzf pgcluu-2.0.tar.gz tar (c

Re: [GENERAL] pgcluu

/lib64/per l5 /usr/share/perl5) at Makefile.PL line 142. wheni trying test Harness it is also not installing.. let me know how to fix issue..? thanks, rao On Sat, Aug 9, 2014 at 9:43 AM, Adrian Klaver wrote: > On 08/08/2014 06:40 AM, Ramesh T wrote: > >> Hi, >>

Re: [GENERAL] pgcluu

Harness > > or downloaded the tar package and install it > > http://search.cpan.org/~leont/Test-Harness-3.32/lib/Test/Harness.pm > > I hope this help you. > > David > > > On 08/11/2014 08:52 AM, Ramesh T wrote: > > Hello , > > I specified correct metho

Re: [GENERAL] pgcluu

where need to install Test-Harness-3.32. or ExtUtis/MakeMaker.pm in pg cluu -2.0 folder or /usr/local/lib64/perl.. please let me know advance thanks.. On Tue, Aug 12, 2014 at 3:20 PM, Ramesh T wrote: > Hi, > I don't have the root permission for yum. > secondly

[GENERAL] pgbadger download

can any one send me link pgbadger 6 for me .. advance thanks,

[GENERAL] POWA tool

Hello, when i ran following query, postgres=# SELECT * FROM pg_stat_statements; ERROR: relation "pg_stat_statements" does not exist LINE 1: SELECT * FROM pg_stat_statements; i need to install POWA..i got powa.zip please let me know how

Re: [GENERAL] POWA tool

yes, in my postgres.conf pg_stat_statements is not their needs powa is released 19 aug. On Wed, Aug 20, 2014 at 10:17 PM, Raghu Ram wrote: > On Wed, Aug 20, 2014 at 10:08 PM, Raymond O'Donnell wrote: > >> On 20/08/2014 16:41, Ramesh T wrote: >> > Hello, >>

Re: [GENERAL] POWA tool

How to include pg_stat_statements in postgres.conf.powa is need it. any help.. thanks, On Wed, Aug 20, 2014 at 11:51 PM, Ramesh T wrote: > yes, > > in my postgres.conf pg_stat_statements is not their needs powa is > released 19 aug. > > > On Wed, Aug 20, 2014 at 10:17 P

Re: [GENERAL] POWA tool

i downloaded But where i need to unzip powa-REL_1_1.zip i'm using putty tool remote server.. -bash-4.1$ unzip powa-REL_1_1.zip -bash: unzip: command not found On Tue, Aug 26, 2014 at 12:55 AM, Raghu Ram wrote: > > On Fri, Aug 22, 2014 at 4:40 PM, Ramesh T > wrote: >

[GENERAL] Deletion

Hi, I have deletion script to delete particular cust from database.I was saved a file name with custde.sql.i need to run from command line like putty tool..But have a problem example : delete from part where part.custid=$1; when i ran custde.sql from putty tool db=#\i custde.sql it

Re: [GENERAL] Deletion

n script ... On Wednesday, August 27, 2014, Adrian Klaver wrote: > On 08/27/2014 08:24 AM, Ramesh T wrote: > >> any help... >> > > Honestly, this is basic programming/scripting. I would suggest picking up > an introductory programming book to get the basics down. > In t

[GENERAL] Failback to old master

Hello, I swear I have read a couple of old threads. Yet I am not sure if it safe to failback to the old master in case of async replication without base backup. Considering: I have the latest 9.3 server A: master B: slave B is actively connected to A I shut down A manually with -m fast (it's the

Re: [GENERAL] Deletion

know.. On Thu, Aug 28, 2014 at 1:20 AM, Adrian Klaver wrote: > On 08/27/2014 11:59 AM, Ramesh T wrote: > >> >> In oracle I ran the deletion script to clean up the particular database >> using custid.custid is the parameter .&&1 is used in the oracle Inthe >> s

[GENERAL] stackbuilder

Hi, I had installed pgadmin3 but not selected stackbuilder ,let me know how to add stackbuilder to pgadmin3 for additional addons.. thanks, ram

Re: [GENERAL] stackbuilder

any help.. On Tue, Sep 9, 2014 at 4:06 PM, Ramesh T wrote: > Hi, > > I had installed pgadmin3 but not selected stackbuilder ,let me know > how to add stackbuilder to pgadmin3 for additional addons.. > > thanks, > ram > > >

Re: [GENERAL] phppgadmin

tell me good guidelines for phppgadmin..? On Thu, Nov 6, 2014 at 8:54 PM, Ramesh T wrote: > hello, > any guidelines is their how to use these tool..? > not home site.. > http://phppgadmin.kattare.com/phppgadmin/...:) >

  1   2   3   4   5   6   >