On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar
> wrote:
>
>> Hi,
>>
>> In PostgreSQL a user can alter itself to change its user level
>> parameters. e.g.
On Sat, 11 Apr 2015 16:05 David G. Johnston
wrote:
On Friday, April 10, 2015, Sameer Kumar wrote:
On Sat, Apr 11, 2015 at 12:57 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
On Fri, Apr 10, 2015 at 9:01 AM, Sameer Kumar
wrote:
Yes either an upper bound to which use
On Mon, 13 Apr 2015 11:35 Jim Nasby wrote:
On 4/11/15 4:11 PM, Sameer Kumar wrote:
> Pg_settings currently has an upper bound column - though it is a
> view and that value cannot be changed that I know of.
>
>
> I guess that upper bound column is more of the limit tha
On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby wrote:
> On 4/12/15 11:55 PM, Sameer Kumar wrote:
> >
> > On Mon, 13 Apr 2015 11:35 Jim Nasby > <mailto:jim.na...@bluetreble.com>> wrote:
> >
> > On 4/11/15 4:11 PM, Sameer Kumar wrote:
> > >
On Tue, 14 Apr 2015 11:59 Ilya Ashchepkov wrote:
On Mon, 13 Apr 2015 12:24:11 -0700
Adrian Klaver wrote:
> On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote:
> > On Mon, 13 Apr 2015 10:06:05 -0700
> > Adrian Klaver wrote:
> >
> >> On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote:
> >>> On Sun, 12 Ap
Sorry about the long silence on this.
On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Sun, Apr 12, 2015 at 10:23 PM, Sameer Kumar
> wrote:
>
>> On Mon, Apr 13, 2015 at 1:03 PM Jim Nasby
>> wrote:
>>
>
>>>
On Tue, May 5, 2015 at 1:44 PM David G. Johnston
wrote:
> On Mon, May 4, 2015 at 10:23 PM, Sameer Kumar
> wrote:
>
>> Sorry about the long silence on this.
>>
>> On Mon, Apr 13, 2015 at 3:34 PM David G. Johnston <
>> david.g.johns...@gmail.com> wrote:
On Fri, May 8, 2015 at 2:29 PM James Sewell
wrote:
> Hello All,
>
> I am running 9.4 on Centos.
>
> I have three servers, one master and two slaves. The slaves have the
> following recovery.conf
>
> standby_mode = 'on'
> primary_conninfo = 'user=postgres host=mastervip port=5432'
> restore_comman
On Tue, 16 Jun 2015 16:55 Xavier 12 wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
(hot_standby).
Psql01 (master) is backuped with Barman and pg_xlogs is correctly
purged (archive_command is used).
Hower, Psql02 (sl
On Wed, 17 Jun 2015 15:24 Xavier 12 wrote:
On 17/06/2015 03:17, Sameer Kumar wrote:
On Tue, 16 Jun 2015 16:55 Xavier 12 wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql 9.1 servers in a master/slave stream replication
(hot_standby).
Psql01 (master) is backuped
On Thu, 18 Jun 2015 15:17 Xavier 12 wrote:
On 18/06/2015 04:00, Sameer Kumar wrote:
On Wed, 17 Jun 2015 15:24 Xavier 12 wrote:
On 17/06/2015 03:17, Sameer Kumar wrote:
On Tue, 16 Jun 2015 16:55 Xavier 12 wrote:
Hi everyone,
Questions about pg_xlogs again...
I have two Postgresql
On Fri, 19 Jun 2015 13:46 Michael Paquier wrote:
On Fri, Jun 19, 2015 at 2:38 PM, James Sewell
wrote:
Hey All,
Is it possible to create WAL archive files on standby servers when using
streaming replication?
Yes and no, standbys do not archive WAL in ~9.4, but you could use
archive_mode = 'al
On Wed, Jul 1, 2015 at 3:37 AM Lukasz Wrobel <
lukasz.wro...@motorolasolutions.com> wrote:
> Hello.
>
> I have multiple problems with my database, the biggest of which is how to
> find out what is actually wrong.
>
> First of all I have a 9.3 postgres database that is running for about a
> month.
On Wed, Jul 1, 2015 at 4:51 AM Pavel Stehule
wrote:
> Hi
>
> What is an output of VACUUM VERBOSE statement?
>
> VACUUM can be blocked by some forgotten transaction. Check your
> pg_stat_activity table for some old process in "idle in transaction" state.
> Then connection should not be reused, and
On Thu, Jul 2, 2015 at 9:57 PM Lukasz Wrobel <
lukasz.wro...@motorolasolutions.com> wrote:
> Hello again.
>
> Thank you for all your responses. I will try to clarify more and attempt
> to answer the questions you raised.
>
> I'm attaching the postgresql.conf this time. I cannot supply you guys wit
ut probably you can check the pid of wal receiver and
find out what host it is connected to (should be possible from network
stats).
> --Scott
>
>
>
>> Regards,
>>>
>>> Bertrand
>>>
>>
>>
>>
>> --
>> *Melvin Davidson*
>
> The Russian Postgres Company
>
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
On Fri, Jun 3, 2016 at 4:30 AM Stephen Frost wrote:
> * Sameer Kumar (sameer.ku...@ashnik.com) wrote:
> > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov,
> > wrote:
> > > Can I list all WAL files in pg_xlog by using some sql query in
> Postgres?
> >
> >
not sure if this is the reason or right use case for SET ROLE.
Using different users (either with same app server or different) is the
best way if ensuring data is not accessible across organizations.
> Are there other options?
>
> Profuse appreciation for your thoughts and suggestions,
>
J.
> >
> >
> >
> >
> >
> > I've never used this tool so like everyone else I am guessing here
> > but having quickly looked at the documentation have you tried
> > specifying the '-targetdbtype postgres' in addition to the
> > '-sourcedbtype sqlserver' that you have already specified?
> >
> > Neil A
> >
> >
> >
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@postgresql.org
> > <mailto:pgsql-general@postgresql.org>)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
> >
> >
>
> That appears to be an issue finding the right Java library to connect to
> Postgres. The documentation here outlines where to download and install
> the JDBC drivers
>
> https://www.enterprisedb.com/docs/en/9.5/migrate/Postgres_Plus_Migration_Guide.1.13.html#
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
>
> Make sure to perform a base backup as soon as your bulk load is finished.
>
> Yours,
> Laurenz Albe
>
> --
>
> Francesco,
>
> Check CREATE UNLOGGED TABLE... in the docs.
>
> Regards,
> Igor
>
>
> --
> Sent via pgsql-general mailing list (pgsql-genera
gt;
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
your
records, instead of locking them. Or look at advisory locks (but that
depends on your Postgres version).
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-gener
an use function with SELECT on same table in CHECK constraint. So
test it out first.
If this works, any insert trying to get the 4th record in table would fail.
A last resort could be using triggers. But either of these approaches will
cause issues if you have high concurrency.
>
>
> On
mode specified)
I am using PostgreSQL v9.4.
Regards
Sameer
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
On Thu, Jun 23, 2016 at 11:57 PM Adrian Klaver
wrote:
> On 06/23/2016 08:14 AM, Sameer Kumar wrote:
> >
> > Hi,
> >
> > I just wanted to understand what are the commands which will acquire
> > Access Exclusive Lock on a table? In my knowledge below operations
On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
> wrote:
> >
> > Hi,
> >
> > I just wanted to understand what are the commands which will acquire
> Access
> > Exclusive Lock on a table? In my knowledge b
On Fri, 24 Jun 2016, 1:54 a.m. Sameer Kumar,
wrote:
>
>
> On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
>
>> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
>> wrote:
>> >
>> > Hi,
>> >
>> > I just wanted to understand what are the
On Fri, 24 Jun 2016, 6:23 a.m. Jeff Janes, wrote:
> On Thu, Jun 23, 2016 at 10:54 AM, Sameer Kumar
> wrote:
> >
> >
> > On Fri, 24 Jun 2016, 1:47 a.m. Jeff Janes, wrote:
> >>
> >> On Thu, Jun 23, 2016 at 8:14 AM, Sameer Kumar
> >> wrot
mat (
> -Fc ), it's much more flexible ( andyou can have the sql script but
> asking pg_restore to generate it if you need it, but not the other way
> round ).
>
>
> Francisco Olarte.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To
ed mode). But
since it works using streaming protocol, max_wal_senders on slave01 will be
2(what you have set now) + 1 (for pg_reveivexlog)
> Cheers guys!
> Patrick
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
l
>>
>> It might be helpful as it does something similar to archiving but using
>> streaming protocol (so I think it should work even in cascaded mode). But
>> since it works using streaming protocol, max_wal_senders on slave01 will be
>> 2(what you have set now) + 1 (fo
On Thu, 7 Jul 2016, 9:52 a.m. Sameer Kumar, wrote:
>
>
> On Thu, 7 Jul 2016, 9:51 a.m. Patrick B, wrote:
>
>>
>>>
>>> On Thu, 7 Jul 2016, 9:20 a.m. Patrick B,
>>> wrote:
>>>
>>>> Hi guys,
>>>>
>>>> I
On Thu, 7 Jul 2016, 9:59 a.m. John R Pierce, wrote:
> On 7/6/2016 6:52 PM, Sameer Kumar wrote:
>
>
>> the only way to archive the wal_files from a slave into another slave on
>> PostgreSQL 9.2, is by using pg_reveivexlog?
>>
>
> Yes. Though I have never tried th
meline, and slave02 won't be able to
> become a master in the future.
>
No, you should not have a problem. Since rsync will also copy the timeline
related files to slave02
> Is that right?
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil S
opy the archives generated on master to a shared location or may be
copy it to S3 bucket
2. Archive generated on master is rsync (schedule basis) to EC2
3. pg_receivexlog running on EC2 to copy WAL from slave01
can just be a archive_command and archive_mode = on?
>
Setting these parameters on
On Thu, Jul 7, 2016 at 11:02 AM Patrick B wrote:
> 2016-07-07 14:55 GMT+12:00 Sameer Kumar :
>
>>
>>
>> On Thu, 7 Jul 2016, 10:32 a.m. Patrick B,
>> wrote:
>>
>>> The slave02 server will be a copy of the DB into Amazon. There will be a
>>>
On Thu, Jul 7, 2016 at 11:37 AM Patrick B wrote:
> 2016-07-07 15:19 GMT+12:00 Sameer Kumar :
>
>>
>>
>> On Thu, Jul 7, 2016 at 11:02 AM Patrick B
>> wrote:
>>
>>> 2016-07-07 14:55 GMT+12:00 Sameer Kumar :
>>>
>>>>
>>>&
lend.ru'
>
> b2b(> INSERT INTO oko_topsites VALUES('russian_federation','calorizator.ru
> ',0,NULL,5)
>
> Unclosed quotes, unclosed parenthesis - anyway it wont work.
>
> How to safely insert big number of statements to psql at once?
> I am aware abo
tools like TeamViewer or WebEx etc over slow network
> Dmitry Shalashov, surfingbird.ru & relap.io
>
> 2016-07-07 20:26 GMT+03:00 Sameer Kumar :
>
>>
>>
>> On Fri, 8 Jul 2016, 1:23 a.m. Dmitry Shalashov,
>> wrote:
>>
>>> Hi everyone.
>>>
>&
on the sql server side )
>
> You still can have problems IF you have updates to the tables, or
> deletions, or . But
> if you just have insertions, copy is easy to do.
>
> Francisco Olarte.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Fri, 8 Jul 2016, 8:06 p.m. Prashanth Adiyodi,
wrote:
> Hi Sameer, Please see comments inline
>
>
>
>
>
> *Prashanth Adiyodi *
>
> *Technical Account Manager*
>
> *Skype: prashanth.adiyodi*
>
> *Mob: +91-9819488395*
>
> [image: celltick]
>
>
urs...
> We couldn't use the directory -Fd dump because it's postgresql 9.1.
> The original database is still on the server, this is a test restore.
>
> We have about one or two months of slack before we really need to remove
> them from the server to recover space.
>
>
> --
> Miguel Ramos
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
GB
> work_mem = 42MB
> maintenance_work_mem = 2GB
> effective_cache_size = 44GB
>
>
what are the values of random_page_cost and seq_page_cost?
Also what might help here is the number of rows and pages in the table -
select relpages,reltuples, relname from pg_class where relname in ('
--
>
> Bitmap Heap Scan on json_tables (cost=113.50..37914.64 rows=1
> width=1261) (actual time=779.261..29815.262 rows=909091 loops=1)
>Recheck Cond: (data @> '{"name": "AC3 Case Red"}'::jsonb)
> Rows Remove
on:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
sional: http://www.postgrespro.com
> The Russian Postgres Company
>
>
> On 20.07.2016 21:02, Sameer Kumar wrote:
>
>
>
> On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov,
> wrote:
>
>> Hello everyone!
>>
>> Is there any way to make pg_dump(9.5) to dump table (with da
und here.
>
> About myself, I am German, currently traveling back and forth between
> Germany and Malaysia.
>
> Torsten
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mai
argest value is from pg_stat_user_tables.
tup_returned (470440261405). Does the statistics get reset automatically
when the value for one of the statistics reaches the high number supported
by int4?
I am running on Red Hat 6.7.
Regards
Sameer
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*AS
On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver,
wrote:
> On 07/24/2016 09:58 PM, Sameer Kumar wrote:
> > Hi,
> >
> > I have PostgreSQL v9.4.4 running in my environment. It has been up for
> > over 2 years now. I noticed that suddenly the statistics have been reset
On Mon, 25 Jul 2016, 10:35 p.m. Adrian Klaver,
wrote:
> On 07/25/2016 07:28 AM, Sameer Kumar wrote:
> >
> >
> > On Mon, 25 Jul 2016, 10:10 p.m. Adrian Klaver,
> > mailto:adrian.kla...@aklaver.com>> wrote:
> >
> > On 07/24/2016 09:58 PM, Sameer Kum
to achieve this?
>
> Regards...
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
On Tue, 26 Jul 2016, 9:20 p.m. Dev Kumkar, wrote:
> On Tue, Jul 26, 2016 at 6:29 PM, Sameer Kumar
> wrote:
>
> You mean you don't want any routines/functions written in Pl/perl or
>> PL/pythin to get executed?
>>
>> If that is what you are looking for them sim
> Aug 10 15:28:39 DB-1 postgres[3314]: [17-2] STATEMENT: INSERT INTO
>
> ActiveRadiussession(AccountSessionId,StationMAC,StationIP,StationIPV6,ApMAC,SSID,Username,WlanMAC,ChargeableUserIdentity,NASIPAddress,SessionStartTime,Port,
> ZoneWlanInfo, AppVMInstanceIP)
> values($1,$2,$3,$4,$5
s email are confidential and may be subject to legal or
> professional privilege and copyright. No representation is made that this
> email is free of viruses or other defects. If you have received this
> communication in error, you may not copy or distribute any part of it or
> otherwise disclose its contents to anyone. Please advise the sender of your
> incorrect receipt of this correspondence.
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
I would not recommend doing this if
you use your standby for other read queries or for high availability.
Another option would be avoid such queries which causes Exclusive Lock on
the master database during pg_dump.
Cheers
>
> Patrick
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
On Wed, Aug 17, 2016 at 11:36 AM Patrick B wrote:
>
>
> 2016-08-17 15:31 GMT+12:00 Sameer Kumar :
>
>>
>>
>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
>> wrote:
>>
>>> Hi guys,
>>>
>>> I'm using PostgreSQL 9.2 and I got
On Wed, Aug 17, 2016 at 12:00 PM Venkata B Nagothi
wrote:
> On Wed, Aug 17, 2016 at 1:31 PM, Sameer Kumar
> wrote:
>
>>
>>
>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
>> wrote:
>>
>>> Hi guys,
>>>
>>> I'm using PostgreSQ
ions of a table at once - it might
lead a page level lock which might conflict with SELECT/share locks on
standby
2. Any REINDEX operations
3. DDL operation
4. VACUUM FULL
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
table would
> generally be a good idea, which makes it easy for tracking activities.
>
> Regards,
> Venkata B N
>
> Fujitsu Australia
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
ed the TABLESAMPLE clause in v9.5?
https://wiki.postgresql.org/wiki/TABLESAMPLE_Implementation
> Thanks!
> /Victor
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
On Fri, Aug 19, 2016 at 2:25 PM Victor Blomqvist wrote:
> On Fri, Aug 19, 2016 at 1:31 PM, Sameer Kumar
> wrote:
>
>>
>>
>> On Fri, 19 Aug 2016, 1:07 p.m. Victor Blomqvist, wrote:
>>
>>> Hi,
>>>
>>> Is it possible to break/limit
his data once it is in Postgres.
> Regards,
> Thomas
>
>
> --
> Thomas Guettler http://www.thomas-guettler.de/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpre
; In the end, PG or ES, all depends on what you want.
>
> -Andy
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350
Skype: sameer.ashnik | www.ashnik.com
other components
of Elastic Stack like logstash and beats. They can be helpful even when you
use Postgres as the end point. Otherwise (IMHO), you would spend a lot of
time writing scripts and jobs to capture and stream logs. If I were you, I
would not want to do that.
> Regards,
>
_trunc('day', tasks_start at TIME ZONE 'EST')
Note: I have not tried this statement
Is this something you are going to use often? If that is the case then
consider to re-model your query. The moment you use an expression on a
column it would not use a normal BTree index.
>
ke changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards,
*Sameer Kumar | DB Solution Architect*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
T: +65 6438 3504 | www.ashnik.com
Skype: sameer.ashnik | T: +65 8110 0350
[image: www.ashnik.com] <http://www.ashnik.com/>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards,
*Sameer Kumar | DB Solution Architect*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong
e help on how we can migrate data from DB2 zOS database to
> > postgres database.
> >
> > Are there any utilities present? Any thoughts how we should approach?
>
> You can use this utility: https://github.com/dalibo/db2topg
>
> The README should provide all needed i
hot_standby_feedback is off, I might face an issue with
rows being removed by vacuum. But that did not happen. Can someone help me
to understand how MVCC, autovacuum work with Streaming replication.
Regards
Sameer
--
--
Best Regards,
*Sameer Kumar | DB Solution Architect*
*ASHNIK PTE. LTD.*
101 Cecil
On Fri, 16 Dec 2016, 12:10 a.m. Sameer Kumar,
wrote:
> Hi,
>
> I was wondering if there is some change in the way
> max_standby_streaming_delay and hot_standby_feedback work in v9.5.
>
> Below is a scenario which I had built to test out something but the
> behavior confuse
; --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
l-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
m.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
p makes sense.
>
I am not sure if it is because of that but you are on an old patch. Upgrade
to latest (I guess 9.1.21).
Once you have upgraded, re-create the stand by from scratch using a
basebackup and then see if the error is still there.
> Best regards,
> Martin
>
--
--
Best Re
ble(s)?
Which version of PostgreSQL? What's the version of OS?
Check out the locks which are not granted yet - pg_locks.granted
> Your help is appreciated.
>
> Thanks and regards,
> Vineel.
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
(pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
s. The system has a total memory of
> 24 GB, runs on Debian and uses an 4Ghz 8 core i7-4790 processor.
>
> Some important postgresql.conf readouts:
>
> - shared_buffers = 4GB
> - work_mem = 64MB
> - maintenance_work_mem = 1GB
> - checkpoint_segments = 50
> - checkpoint_completion_target = 0.9
> - autovacuum = on
>
> Is there something I am missing here? Any help on getting this join faster
> is much appreciated.
>
> Cheers,
> Tim
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
gt; strictly prohibited. If you have
> received this email in error please delete it and notify the sender
> immediately. .
>
> ---
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
the bloats
percentage in the index. If this is true, perhaps a reindex might help.
> "idx_scan", "idx_tup_read" and "idx_tup_fetch" are 0.
> So, it's safe to say that they are not being used, is that right?
>
> But some indexes have almost 100GB on the size column. This means they are
> not being used now, but they could be used in the past?
>
> - Is it safe to remove them?
>
> Cheers
> Lucas
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
hat are worth
> investigating.
>
>
> David J.
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
902708.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sam
ld be far faster, and maybe safer than CSVs
>
I don't think assumption is right. COPY is not meant for backup, it is for
LOAD and UN-LOAD.
What you probably need is pg_dump with -Fc format.
http://www.postgresql.org/docs/current/static/app-pgdump.html
>
> Thanks by advance,
&
On Tue, May 10, 2016 at 4:36 PM Sameer Kumar
wrote:
> On Tue, May 10, 2016 at 4:26 PM Nicolas Paris wrote:
>
>> Hello,
>>
>> What is the way to build a binary format (instead of a csv) ? Is there
>> specification for this file ?
>> http://www.postgres
ve and then other way
> round, but, this can be clarified only if you let us know the postgresql
> version. This is quite tricky in 9.2.x and from 9.3.x.
>
> Regards,
> Venkata B N
>
> Fujitsu Australia
>
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
gt;
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
put is :
>
> c1 | c2 | array_to_string
> ++-
> 2 | 20 | 2,3
> 1 | 10 | 2,3
> 3 | 30 | 2,3
>
> Could one of you help me with the correct query.
>
>
>
May you should share some more details of exactly what you are expecting
and what is the
ead
if bested select and use that with OUTER JOIN or may be in the inner query
use a correlated where clause (where t1.c2=t2.c2)
> to get me the output desired.
>
> Thanks
> Shankha Banerjee
>
>
> On Wed, May 18, 2016 at 1:57 PM, Sameer Kumar
> wrote:
> >
> >
created.
Though I don't think this infra has been built for this very purpose.
> --
> john r pierce, recycling bits in santa cruz
>
> --
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
.@gmail.com&idSignature=22>
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
g=en&referral=alukaraju2...@gmail.com&idSignature=22>
>
> On Mon, May 23, 2016 at 10:37 AM, Sameer Kumar
> wrote:
>
>>
>>
>> On Mon, 23 May 2016, 1:03 p.m. aluka raju,
>> wrote:
>>
>>> Hello,
>>>
>>> I want use my da
l mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
lan without parallel worker.
Perhaps if you reduce the both parameters by same factor/margin, you can
see that parallel execution will be preffered when it is of lower cost.
> Regards
> Thomas
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
any way to specify in recovery.conf or otherwise that I would
allow me to do recovery of transactions of a particular tablespace? A
custom solution which occurs to me is using pg_xlogdump contrib. Has anyone
tried something similar?
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE
parameter file here.
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
*[image: icons]*
[image: Email patch] <http://www.ashnik.com/>
This email may c
eaming protocol and needs wal-sender
processes.
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65 8110 0350* T: +65 6438 3504 | www.ashnik.com
*[image: icons]*
[image: Email patch] <http://www.a
Hi,
Postgres optimizer automatically tries to convert an IN clause to Hash Join
(something similar to EXISTS equivalent of that query).
Does a similar translation happen for NOT IN as well? Given that the column
used is NOT NUL.
Select * from emp where deptid not in (select deptid from dept wher
has been imbued with ever increasing smarts, the
> need to test and choose between the two seems to have diminished.
Postgres already does that for IN and EXISTS. Both would try to use HASH.
But does not seem to be the case with NOT IN and NOT EXISTS.
Best Regards,
*Sameer Kumar | D
slate a NOT IN plan similar to
> > NOT EXISTS plan?
>
> It will, hopefully in 9.5.
>
> https://commitfest.postgresql.org/action/patch_view?id=1487
Cool!
Will be looking forward to it! But seems a long way from now...
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHN
Patrol, going through a
few threads tells me that it can integrated with BMC patrol via sentry
monitoring studio and customer script.
Has anyone tried it?
Best Regards,
*Sameer Kumar | Database Consultant*
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M: *+65
1 - 100 of 171 matches
Mail list logo
