Here selinux is already disabled on server and I am installing postgres on
Centos 7.2.
On Fri, Jan 29, 2016 at 1:12 PM, John R Pierce wrote:
> On 1/28/2016 11:21 PM, Sachin Srivastava wrote:
>
>>
>> Is it not possible If my storage is mounted on /u01 and I will create the
>> directory within "
On 1/28/2016 11:21 PM, Sachin Srivastava wrote:
Is it not possible If my storage is mounted on /u01 and I will create
the directory within "u01/" /postgres9.4/data. And now I want to
initialize my data within this directory ("/u01/postgres9.4/data").
There is any specific reason to use onl
Dear John,
Thanks for update !!!
Is it not possible If my storage is mounted on /u01 and I will create the
directory within "u01/" /postgres9.4/data. And now I want to initialize
my data within this directory ("/u01/postgres9.4/data").
There is any specific reason to use only this by default d
On 1/28/2016 10:24 PM, Sachin Srivastava wrote:
I have initialized the database through below command through Postgres
user but in my "/u01/postgres9.4/" folder pg_log folder is not
available, what is the reason behind this.
---
-bash-4.2$ initdb -D /u01/postgr
Dear Adrian,
I have initialized the database through below command through Postgres user
but in my "/u01/postgres9.4/" folder pg_log folder is not available, what
is the reason behind this.
---
-bash-4.2$ initdb -D /u01/postgres9.4/
The files belonging to this d
On 01/28/2016 08:45 PM, Sachin Srivastava wrote:
Hi,
I have to install Postgres 9.4.5 On Centos 7.2, what is the best way to
install, please suggest:
Through ./configure and make
OR
Through below link:
https://wiki.postgresql.org/wiki/YUM_Installation#Configure_your_YUM_repository
Please
Hi,
I have to install Postgres 9.4.5 On Centos 7.2, what is the best way to
install, please suggest:
Through ./configure and make
OR
Through below link:
https://wiki.postgresql.org/wiki/YUM_Installation#Configure_your_YUM_repository
Please provide, if any other installation document.
For
On Fri, Jan 29, 2016 at 1:55 AM, David G. Johnston wrote:
> Could you run the following and post the result, please? I have yet to
> setup a compiled-from-source installation...
>
> \pset title 'This is a medium length title'
> SELECT repeat('a', 100) \watch 5
>
> It seems fine though I'm curious
On 01/28/2016 05:23 PM, drum.lu...@gmail.com wrote:
Hi there!
I'm running this command: *(Trying to copy a full DB (2TB) from a
hot-standby server to a master (test) server)*
|ssh postgres@myslaveserver "/usr/pgsql-9.2/bin/pg_dump
--exclude-table-data='junk.*' -—format=custom
master_db"|/usr/pg
Hi there!
I'm running this command: *(Trying to copy a full DB (2TB) from a
hot-standby server to a master (test) server)*
ssh postgres@myslaveserver "/usr/pgsql-9.2/bin/pg_dump
--exclude-table-data='junk.*' -—format=custom master_db" |
/usr/pgsql-9.2/bin/pg_restore --dbname=master_db_temp --exit
I go to read the repmgr quickstart and get a 404?
https://github.com/2ndQuadrant/repmgr/blob/master/QUICKSTART.md
I was on this page yesterday and it was fine.
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
I am creating a small booking system, and need to generate a series of
dates, for the year, with each booking. Using generate_series I can create
the dates, and fill them with a booking date based on the lower tsrange for
the booking.
I need to extend this to also fetch ALL the dates in the tsrange
2016-01-28 16:03 GMT-02:00 Joshua D. Drake :
> On 01/28/2016 09:41 AM, Melvin Davidson wrote:
>
>> So, IOW, and the answer to my question is yes, it should be insured that
>> all pages involved are physically adjacent (by design or by pre-sort)
>> before creating a BRIN on them.
>> Further to the
On 01/28/2016 09:41 AM, Melvin Davidson wrote:
So, IOW, and the answer to my question is yes, it should be insured that
all pages involved are physically adjacent (by design or by pre-sort)
before creating a BRIN on them.
Further to the point, it is self defeating to have more than one BRIN
index
So, IOW, and the answer to my question is yes, it should be insured that
all pages involved are physically adjacent (by design or by pre-sort)
before creating a BRIN on them.
Further to the point, it is self defeating to have more than one BRIN index
on the table if the columns involved would have
I'm using 9.4.5 as well and I used exactly the same iconv lines as you
postes below.
Are there any encoding options that have to be set right? The database
encoding is set to UTF8.
ww
Am 2016-01-28 um 17:34 schrieb Artur Zakirov:
On 28.01.2016 18:57, Oleg Bartunov wrote:
On Thu, Jan 28,
On 29 January 2016 at 06:10, Melvin Davidson wrote:
> With regard to BRIN indexes:
>
> http://www.postgresql.org/docs/9.5/interactive/brin-intro.html
>
> 62.1. Introduction
>
> "A block range is a group of pages that are physically adjacent in the
> table; for each block range, some summar
Melvin Davidson wrote:
> With regard to BRIN indexes:
>
> http://www.postgresql.org/docs/9.5/interactive/brin-intro.html
>
> 62.1. Introduction
>
> "A block range is a group of pages that are physically adjacent in the
> table; for each block range, some summary info is stored by the inde
Reposting because I received no reply from a previous inquiry as "9.5 new
features".
With regard to BRIN indexes:
http://www.postgresql.org/docs/9.5/interactive/brin-intro.html
62.1. Introduction
"A block range is a group of pages that are physically adjacent in the
table; for each block
Bala Venkat wrote:
> Hi there -
>
> We have a set up where there is One master streaming to 3 Slaves .
> 2 slaves are in our DR environment. One is the prod environment.
>
> Wanted to make the DR as primary. I know we can make the one of the
> slave in DR to primary. If I
On 28 Jan 2016 6:51 pm, "Craig Ringer" wrote:
>
> On 28 January 2016 at 21:16, Kaushal Shriyan
wrote:
>>
>>
>>
>> On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer
wrote:
>>>
>>> On 28 January 2016 at 19:16, Kaushal Shriyan
wrote:
Hi,
Can somebody please help me understand the d
On Thu, Jan 28, 2016 at 6:01 AM, Michael Paquier
wrote:
> On Thu, Jan 28, 2016 at 1:54 PM, David G. Johnston
> wrote:
> > On Wed, Jan 27, 2016 at 9:13 PM, Michael Paquier <
> michael.paqu...@gmail.com>
> > wrote:
> >>
> >> On Thu, Jan 28, 2016 at 9:34 AM, David G. Johnston
> >> wrote:
> >> > So
On 28.01.2016 18:57, Oleg Bartunov wrote:
On Thu, Jan 28, 2016 at 6:04 PM, Wolfgang Winkler
mailto:wolfgang.wink...@digital-concepts.com>> wrote:
Hi!
We have a problem with importing a compound dictionary file for german.
I downloaded the files here:
http://www.sai.msu.su/~
On Thu, Jan 28, 2016 at 6:04 PM, Wolfgang Winkler <
wolfgang.wink...@digital-concepts.com> wrote:
> Hi!
>
> We have a problem with importing a compound dictionary file for german.
>
> I downloaded the files here:
>
>
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-germ
Hi!
We have a problem with importing a compound dictionary file for german.
I downloaded the files here:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz
and converted them to utf-8 with iconv. The affix file seems ok when
opened with an editor
Hi there -
We have a set up where there is One master streaming to 3 Slaves
. 2 slaves are in our DR environment. One is the prod environment.
Wanted to make the DR as primary. I know we can make the one of
the slave in DR to primary. If I want to keep the other slave as sla
On 28 January 2016 at 21:16, Kaushal Shriyan
wrote:
>
>
> On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer
> wrote:
>
>> On 28 January 2016 at 19:16, Kaushal Shriyan
>> wrote:
>>
>>> Hi,
>>>
>>> Can somebody please help me understand the difference between UDR and
>>> BDR with examples?
>>>
>>
>>
On Thu, Jan 28, 2016 at 6:32 PM, Craig Ringer wrote:
> On 28 January 2016 at 19:16, Kaushal Shriyan
> wrote:
>
>> Hi,
>>
>> Can somebody please help me understand the difference between UDR and BDR
>> with examples?
>>
>
>
> BDR is for multiple masters that all replicate to each other.
>
> UDR t
On 28 January 2016 at 19:16, Kaushal Shriyan
wrote:
> Hi,
>
> Can somebody please help me understand the difference between UDR and BDR
> with examples?
>
BDR is for multiple masters that all replicate to each other.
UDR takes data from one server and copies it to another. One way. (By the
way
On Thu, Jan 28, 2016 at 1:54 PM, David G. Johnston
wrote:
> On Wed, Jan 27, 2016 at 9:13 PM, Michael Paquier
> wrote:
>>
>> On Thu, Jan 28, 2016 at 9:34 AM, David G. Johnston
>> wrote:
>> > So how about:
>> >
>> > + snprintf(title, strlen(myopt.title) + 50,
>> > + _("Watch every %lds\t%s\t%s"),
Hi,
Can somebody please help me understand the difference between UDR and BDR
with examples?
Thanks in Advance.
Regards,
Kaushal
31 matches
Mail list logo