Password encryption

[Azimuddin Mohammed]

Hello,
Is there a way I can encrypt the default password column of db user
password. I know by default the password is encrypted as md5, can we
encrypt that of shadow column for password?

Thanks in advance

Oacle to Postgres migration

[Azimuddin Mohammed]

Hello,
Can anyone suggest me

-- 

Regards,
Azim



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Oracle to postgres migration

[Azimuddin Mohammed]

Hello,
Can anyone guide me through the steps for migration from oracle to postgres
with config changes required, keeping in mind that neither I am a oracle
DBA not postgres admin

-- 

Regards,
Azim



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Production Database requirement

[Azimuddin Mohammed]

Hello All,
Can anyone please let me know

1. What is the hardware and software  requirement for postgressql to be
installed in production. We are planning to use postgres for hadoop
backend, to store user access info, metadata etc. So, it will not be high
transaction db, but we might see lost of reads to this db.

2. Can we use Vm's to run the Db? Is it recommended ?


Thanks in Advance!


-- 

Regards,
Azim



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Postgres HA

[Azimuddin Mohammed]

Hello,
I am little confused with how HA works in postgres. Reading the article
which state as below "*If the primary server fails and the standby server
becomes the new primary, and then the old primary restarts, you must have a
mechanism for informing the old primary that it is no longer the primary.
This is sometimes known as STONITH (Shoot The Other Node In The Head),
which is necessary to avoid situations where both systems think they are
the primary, which will lead to confusion and ultimately data loss.*

*Many failover systems use just two systems, the primary and the standby,
connected by some kind of heartbeat mechanism to continually verify the
connectivity between the two and the viability of the primary. It is also
possible to use a third system (called a witness server) to prevent some
cases of inappropriate failover, but the additional complexity might not be
worthwhile unless it is set up with sufficient care and rigorous testing.*
*PostgreSQL does not provide the system software required to identify a
failure on the primary and notify the standby database server. Many such
tools exist and are well integrated with the operating system facilities
required for successful failover, such as IP address migration."*

Can someone explain how the HA failback will take place and what open
source tools we can use to make sure once the primary server which failed
over to slave will mark itself as slave.

Appreciate your response in advance.

-- 

Regards,
Azim



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: Postgres HA

[Azimuddin Mohammed]

Thank you..I have subscribed to the list..


On Jan 5, 2018 8:09 PM, "Tatsuo Ishii"  wrote:

> Hi,
>
> Yes, definitely I am hanging out here.
>
> If you have more specific questions to Pgpool-II, you are encouraged
> to be subscribed to the Pgpool-II mailing list.
> https://www.pgpool.net/mailman/listinfo/pgpool-general
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > What he said, and you also may want to look at pgpool-II. I’ve had
> fairly good luck with that and Tatsuo (the author) hangs out here
> occasionally too.
> > ―
> > Jay
> >
> > Sent from my iPad
> >
> >> On Jan 5, 2018, at 4:00 PM, Jehan-Guillaume (ioguix) de Rorthais <
> iog...@free.fr> wrote:
> >>
> >> On Fri, 5 Jan 2018 13:07:10 -0600
> >> Azimuddin Mohammed  wrote:
> >>
> >>> Hello,
> >>> I am little confused with how HA works in postgres. Reading the article
> >>> which state as below "*If the primary server fails and the standby
> server
> >>> becomes the new primary, and then the old primary restarts, you must
> have a
> >>> mechanism for informing the old primary that it is no longer the
> primary.
> >>> This is sometimes known as STONITH (Shoot The Other Node In The Head),
> >>> which is necessary to avoid situations where both systems think they
> are
> >>> the primary, which will lead to confusion and ultimately data loss.*
> >>>
> >>> *Many failover systems use just two systems, the primary and the
> standby,
> >>> connected by some kind of heartbeat mechanism to continually verify the
> >>> connectivity between the two and the viability of the primary. It is
> also
> >>> possible to use a third system (called a witness server) to prevent
> some
> >>> cases of inappropriate failover, but the additional complexity might
> not be
> >>> worthwhile unless it is set up with sufficient care and rigorous
> testing.*
> >>> *PostgreSQL does not provide the system software required to identify a
> >>> failure on the primary and notify the standby database server. Many
> such
> >>> tools exist and are well integrated with the operating system
> facilities
> >>> required for successful failover, such as IP address migration."*
> >>>
> >>> Can someone explain how the HA failback will take place
> >>
> >> The failback need either to rebuild the old master as a standby (rsync,
> >> pg_basebackup, restore PITR, ...) or to use pg_rewind to rewind the old
> master
> >> to a point where it can catch up with the new master.
> >>
> >> Some tools tries to automate failback using pg_rewind (patroni,
> repmgr), but I
> >> have no experience with them.
> >>
> >>> and what open source tools we can use to make sure once the primary
> server
> >>> which failed over to slave will mark itself as slave.
> >>
> >> There's a lot of open source tools to build some HA around PgSQL:
> Repmgr,
> >> Patroni (based on etcd or zookeeper), PAF (based on Pacemaker), etc.
> You will
> >> have to spend a lot of time to make extensive tests, understand them,
> pick one
> >> and document your cluster.
> >>
> >> Regards,
> >>
> >
>

Postgres for hadoop

[Azimuddin Mohammed]

Hello,
Has anyone used postgres for hadoop. Of so what is the hardware
configuration.
Or can someone suggest a good hardware configuration or a way I can measure
required hardware config for the db.

Thanks in advance..

Re: Postgres for hadoop

[Azimuddin Mohammed]

Not really...currently i am using oracle for hadoop to store metatdata
information about the hadoop services. We are planning to shift to postgres
and replace oracle as source db.

On Jan 24, 2018 9:21 AM, "Merlin Moncure"  wrote:

> On Wed, Jan 24, 2018 at 1:07 AM, Azimuddin Mohammed 
> wrote:
> > Hello,
> > Has anyone used postgres for hadoop. Of so what is the hardware
> > configuration.
> > Or can someone suggest a good hardware configuration or a way I can
> measure
> > required hardware config for the db.
>
> what is 'postgres for hadoop'?   Do you mean this?
> https://www.enterprisedb.com/blog/hadoop-postgres-%E2%80%93-bridging-gap
>
> merlin
>

Sync replication

[Azimuddin Mohammed]

I have a question regarding synchronus replication.
If i have a master and standby server will sync replication setup..when my
slave dies and master is still active. Will the transaction completes, or
master will wait for slave to commit the transaction and then commits its. ?

Re: Sync replication

[Azimuddin Mohammed]

So untill my slave comes up master does not commit any transaction which
means technically my db is non operative?

On Jan 25, 2018 12:23 PM, "Rakesh Kumar"  wrote:

>
> >I have a question regarding synchronus replication.
> >If i have a master and standby server will sync replication setup..when
> my slave dies and master is still active. Will the transaction completes,
> or >master will wait for slave to commit the transaction and then commits
> its. ?
>
> Master will wait for slave to come back up.  PG"s replication is not the
> same as SQLServer/DB2/Oracle
> where they allow master to continue operating while the slave is down.
> useful during scheduled maintenance.
>
>

postgres for production

[Azimuddin Mohammed]

Hello,
I have a question for postgres hardware requirement for production
installation. My org want to use Vms with only 8 cores max + 64Gb RAM max.
I have 4 database out of which 1 Db is write extensive 1 db is read
extensive and moderate write and 2 other DBs are read with write one.

can someone suggest me is this a good configuration with respect to
hardware ?

Thanks in Advance.

-- 

Regards,
Azim



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: postgres for production

[Azimuddin Mohammed]

thanks for the reply scott.
The reads are pretty quick, we will use pg for reading/storing  metadata
information only. not complex joins run, and the 4 dbs are of different
size , each db around 200 GB max total

On Wed, Jan 31, 2018 at 10:28 AM, Scott Whitney  wrote:

> Not really with only that information. There's a lot more to running any
> database in a virtualized environment.
>
>
> Additionally, 8 cores max? Well, how long does a read or a write take? Are
> these complex SELECTs with multiple joins of millions of rows that return
> in 30s or 1m? If so, do you have 10 people per minute trying to run them?
> If so, life is not going to look good for you.
>
>
> What size are the databases? 4 databases of equal size and equal use? Etc.
> etc.
>
>
> --
> *From:* Azimuddin Mohammed 
> *Sent:* Wednesday, January 31, 2018 10:23 AM
> *To:* pgsql-ad...@postgresql.org; pgsql-gene...@postgresql.org
> *Subject:* postgres for production
>
> Hello,
> I have a question for postgres hardware requirement for production
> installation. My org want to use Vms with only 8 cores max + 64Gb RAM max.
> I have 4 database out of which 1 Db is write extensive 1 db is read
> extensive and moderate write and 2 other DBs are read with write one.
>
> can someone suggest me is this a good configuration with respect to
> hardware ?
>
> Thanks in Advance.
>
> --
>
> Regards,
> Azim
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
> <#m_3830895419825862837_x_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
>
> Journyx, Inc.
> 7600 Burnet Road #300
> <https://maps.google.com/?q=7600+Burnet+Road+%23300+%0D+Austin,+TX+78757&entry=gmail&source=g>
> Austin, TX 78757
> www.journyx.com
>
> p 512.834. <(512)%20834->
> f 512-834-8858 <(512)%20834-8858>
>
> Do you receive our promotional emails? Click here
> <http://journyx.com/communication-preferences>or visit http://journyx.com/
> communication-preferences to unsubscribe.
>



-- 

Regards,
Azim

Postgres install

[Azimuddin Mohammed]

Hello,
I need to install postgres without root privileges. I have a postgres user
in our companies AD.
Below are my questions n concerns:

1. Is there a website you will refer other the postgres documentation, the
one on postgres website is confusing

2. What is the default location of postgress install from a source code?
i.e if I run rmp -ivh  where will it install by default? can this
be changed ?

3. Important parameters I need to change  ? I am planning to have different
drive location for my data directory or any important parameter, please let
me know.


Thanks in Advance

-- 

Regards,
Azim

Fwd: postgres instalation

[Azimuddin Mohammed]

Hello,
I have installed postgres I saw the message postgres installation complete.
But when I look in the install directory I only see
bin
lib
include
share

I do not see man and docs, may I know how I can install the man and docs
and what is the use of it?

-- 

Regards,
Azim




-- 

Regards,
Azim



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: Fwd: postgres instalation

[Azimuddin Mohammed]

I built it from source code.
It says contib is installed too. But i dont see thrm under the prefix
directory.

On Feb 6, 2018 9:17 PM, "Adrian Klaver"  wrote:

> On 02/06/2018 06:05 PM, Azimuddin Mohammed wrote:
>
>>
>> Hello,
>> I have installed postgres I saw the message postgres installation
>> complete. But when I look in the install directory I only see
>> bin
>> lib
>> include
>> share
>>
>> I do not see man and docs, may I know how I can install the man and docs
>> and what is the use of it?
>>
>
> How did you install, from source or via packages?
>
> If from source:
>
> https://www.postgresql.org/docs/10/static/install-procedure.html
>
> "If you want to build everything that can be built, including the
> documentation (HTML and man pages), and the additional modules (contrib),
> type instead:
>
> make world
>
>
>
>
>> --
>>
>> Regards,
>> Azim
>>
>>
>>
>>
>> --
>>
>> Regards,
>> Azim
>>
>>
>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
>>  Virus-free. www.avast.com <https://www.avast.com/sig-ema
>> il?utm_medium=email&utm_source=link&utm_campaign=sig-email&
>> utm_content=webmail&utm_term=link>
>>
>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>

Re: Fwd: postgres instalation

[Azimuddin Mohammed]

May I know the use for doc and man here.
Additionally I see the doc directory is getting created in the build
directory and no the prefix directory I supplied


On Tue, Feb 6, 2018 at 11:16 PM, Shreeyansh Dba 
wrote:

> While you installing PostgreSQL via Source then by default it will contain
> only (Bin, lib, include, share) if you want to install the documentation
> (HTML and man pages)
>  use following command:-
>
> make install-docs.
>
> <http://www.shreeyansh.com>
>
> On Wed, Feb 7, 2018 at 9:11 AM, Adrian Klaver 
> wrote:
>
>> On 02/06/2018 07:32 PM, Azimuddin Mohammed wrote:
>>
>>> I built it from source code.
>>> It says contib is installed too. But i dont see thrm under the prefix
>>> directory.
>>>
>>
>> When you did the original build did you do make world or just make?
>>
>> See also:
>>
>> https://www.postgresql.org/docs/10/static/install-procedure.html
>> "
>> Installing the Files
>> Note
>>
>> If you are upgrading an existing system be sure to read Section 18.6
>> which has instructions about upgrading a cluster.
>>
>> To install PostgreSQL enter:
>>
>> make install
>>
>> This will install files into the directories that were specified in Step
>> 1. Make sure that you have appropriate permissions to write into that area.
>> Normally you need to do this step as root. Alternatively, you can create
>> the target directories in advance and arrange for appropriate permissions
>> to be granted.
>>
>> To install the documentation (HTML and man pages), enter:
>>
>> make install-docs
>>
>> If you built the world above, type instead:
>>
>> make install-world
>>
>> This also installs the documentation.
>> "
>>
>>
>>
>>> On Feb 6, 2018 9:17 PM, "Adrian Klaver" >> <mailto:adrian.kla...@aklaver.com>> wrote:
>>>
>>> On 02/06/2018 06:05 PM, Azimuddin Mohammed wrote:
>>>
>>>
>>> Hello,
>>> I have installed postgres I saw the message postgres
>>> installation complete. But when I look in the install directory
>>> I only see
>>> bin
>>> lib
>>> include
>>> share
>>>
>>> I do not see man and docs, may I know how I can install the man
>>> and docs  and what is the use of it?
>>>
>>>
>>> How did you install, from source or via packages?
>>>
>>> If from source:
>>>
>>> https://www.postgresql.org/docs/10/static/install-procedure.html
>>> <https://www.postgresql.org/docs/10/static/install-procedure.html>
>>>
>>> "If you want to build everything that can be built, including the
>>> documentation (HTML and man pages), and the additional modules
>>> (contrib), type instead:
>>>
>>> make world
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Azim
>>>
>>>
>>>
>>>
>>> --
>>> Regards,
>>> Azim
>>>
>>>
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>>
>>>  Virus-free. www.avast.com <http://www.avast.com>
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=link
>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>>
>>>
>>>
>>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>
>>>
>>>
>>> -- Adrian Klaver
>>> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
>>>
>>>
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com
>>
>>
>


-- 

Regards,
Azim

Re: Fwd: postgres instalation

[Azimuddin Mohammed]

I think I fig out what the issue here
under the ./configure i need to mention man directory as well which I was
missing

let me ask this once the installation is I see a message "PostgreSQL
installation complete" how many directories I should be seeing under my
prefix directory

I am  seeing below files:

bin
extension
html
include
lib
man1
man3
man7
share

On Wed, Feb 7, 2018 at 12:35 AM, Azimuddin Mohammed 
wrote:

> May I know the use for doc and man here.
> Additionally I see the doc directory is getting created in the build
> directory and no the prefix directory I supplied
>
>
> On Tue, Feb 6, 2018 at 11:16 PM, Shreeyansh Dba 
> wrote:
>
>> While you installing PostgreSQL via Source then by default it will
>> contain only (Bin, lib, include, share) if you want to install the
>> documentation (HTML and man pages)
>>  use following command:-
>>
>> make install-docs.
>>
>> <http://www.shreeyansh.com>
>>
>> On Wed, Feb 7, 2018 at 9:11 AM, Adrian Klaver 
>> wrote:
>>
>>> On 02/06/2018 07:32 PM, Azimuddin Mohammed wrote:
>>>
>>>> I built it from source code.
>>>> It says contib is installed too. But i dont see thrm under the prefix
>>>> directory.
>>>>
>>>
>>> When you did the original build did you do make world or just make?
>>>
>>> See also:
>>>
>>> https://www.postgresql.org/docs/10/static/install-procedure.html
>>> "
>>> Installing the Files
>>> Note
>>>
>>> If you are upgrading an existing system be sure to read Section 18.6
>>> which has instructions about upgrading a cluster.
>>>
>>> To install PostgreSQL enter:
>>>
>>> make install
>>>
>>> This will install files into the directories that were specified in Step
>>> 1. Make sure that you have appropriate permissions to write into that area.
>>> Normally you need to do this step as root. Alternatively, you can create
>>> the target directories in advance and arrange for appropriate permissions
>>> to be granted.
>>>
>>> To install the documentation (HTML and man pages), enter:
>>>
>>> make install-docs
>>>
>>> If you built the world above, type instead:
>>>
>>> make install-world
>>>
>>> This also installs the documentation.
>>> "
>>>
>>>
>>>
>>>> On Feb 6, 2018 9:17 PM, "Adrian Klaver" >>> <mailto:adrian.kla...@aklaver.com>> wrote:
>>>>
>>>> On 02/06/2018 06:05 PM, Azimuddin Mohammed wrote:
>>>>
>>>>
>>>> Hello,
>>>> I have installed postgres I saw the message postgres
>>>> installation complete. But when I look in the install directory
>>>> I only see
>>>> bin
>>>> lib
>>>> include
>>>> share
>>>>
>>>> I do not see man and docs, may I know how I can install the man
>>>> and docs  and what is the use of it?
>>>>
>>>>
>>>> How did you install, from source or via packages?
>>>>
>>>> If from source:
>>>>
>>>> https://www.postgresql.org/docs/10/static/install-procedure.html
>>>> <https://www.postgresql.org/docs/10/static/install-procedure.html>
>>>>
>>>> "If you want to build everything that can be built, including the
>>>> documentation (HTML and man pages), and the additional modules
>>>> (contrib), type instead:
>>>>
>>>> make world
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Azim
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards,
>>>> Azim
>>>>
>>>>
>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon
>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>>
>>>>Virus-free. www.avast.com <http://www.avast.com>
>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=link
>>>> <https://www.avast.com/sig-email?utm_medium=email&utm_source
>>>> =link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>>
>>>>
>>>>
>>>> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>>>>
>>>>
>>>>
>>>> -- Adrian Klaver
>>>> adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
>>>>
>>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian.kla...@aklaver.com
>>>
>>>
>>
>
>
> --
>
> Regards,
> Azim
>
>


-- 

Regards,
Azim

LDAP for postgres

[Azimuddin Mohammed]

hello,

Any idea about how I can enable LDAP for  postgres after install ?

-- 

Regards,
Azim

initdb execution

[Azimuddin Mohammed]

Hello I have a question regrading initdb,
My understanding of initdb is when we execute it it will create the
directory structure in /data.
My question is when we run initdb when we already have a database running
and for some reason I run this command what happens to my existing actual
data does it get flushed out ? In that case what is the best practice here?

-- 

Regards,
Azim

Re: initdb execution

[Azimuddin Mohammed]

Thanks for the reply..
Let me execute in the newly built setup.

On Fri, Feb 9, 2018 at 11:50 AM, Francisco Olarte 
wrote:

> Azim
>
> On Fri, Feb 9, 2018 at 6:36 PM, Azimuddin Mohammed 
> wrote:
> > Hello I have a question regrading initdb,
> > My understanding of initdb is when we execute it it will create the
> > directory structure in /data.
> > My question is when we run initdb when we already have a database running
> > and for some reason I run this command what happens to my existing actual
> > data does it get flushed out ? In that case what is the best practice
> here?
>
> I think initdb refuses to run when given an existent non empty
> directory, but cannot find anything in its doc page...
>
> Ok, after a little googling I've found "initdb will refuse to run if
> the data directory exists and already contains files; this is to
> prevent accidentally overwriting an existing installation." in the
> server setup / creating cluster docs (
> https://www.postgresql.org/docs/10/static/creating-cluster.html ).
>
> Francisco Olarte.
>



-- 

Regards,
Azim

postgres not starting

[Azimuddin Mohammed]

Hello,
I am unable to start postgres on one of the server
I am getting below error "HINT: is another postmaster already running on
port 5432, if not wait a few seconds and retry"
I checked the processes nothing is running with postgres

 I think the error caused because I removed everything under /data
directory before stopping the server.
Can someone help.


-- 

Regards,
Azim

postgres started without auto vaccum

[Azimuddin Mohammed]

Hello All,
I am getting below Warning messages in logs after starting postgres, can
some please help me here

LOG: could not bind socket for statistics collector: Cannot assign
requested address

LOG: disabling statistics collector for lack of working socket

WARNING: autovacuum not started because of misconfiguration

HINT : Enable the "track_counts" option.

MultiXact member wraparound protections are now enabled


I tried enabling track_counts but it did not help.


Any guidance is much appreciated here.


Thanks in Advance!


-- 

Regards,
Azim

Re: postgres started without auto vaccum

[Azimuddin Mohammed]

Its on rhel 7.3 , i cant disable firewal, its on one of my company dev
server.

On Feb 16, 2018 12:21 AM, "Andreas Kretschmer" 
wrote:

> On 16 February 2018 06:54:43 CET, Azimuddin Mohammed 
> wrote:
> >Hello All,
> >I am getting below Warning messages in logs after starting postgres,
> >can
> >some please help me here
> >
> >LOG: could not bind socket for statistics collector: Cannot assign
> >requested address
> >
> >LOG: disabling statistics collector for lack of working socket
> >
> >WARNING: autovacuum not started because of misconfiguration
> >
> >HINT : Enable the "track_counts" option.
> >
> >MultiXact member wraparound protections are now enabled
> >
> >
> >I tried enabling track_counts but it did not help.
> >
> >
> >Any guidance is much appreciated here.
> >
> >
> >Thanks in Advance!
>
>
> Which operating system? Please disable all firewalls and try it again.
>
> Regards, Andreas.
>
>
> --
> 2ndQuadrant - The PostgreSQL Support Company
>

Re: postgres started without auto vaccum

[Azimuddin Mohammed]

Yes, I did. The first start happened without any issues. But the next
restart i see the errors.

On Feb 16, 2018 7:54 AM, "Adrian Klaver"  wrote:

> On 02/15/2018 09:54 PM, Azimuddin Mohammed wrote:
>
>> Hello All,
>> I am getting below Warning messages in logs after starting postgres, can
>> some please help me here
>>
>> LOG: could not bind socket for statistics collector: Cannot assign
>> requested address
>>
>> LOG: disabling statistics collector for lack of working socket
>>
>> WARNING: autovacuum not started because of misconfiguration
>>
>> HINT : Enable the "track_counts" option.
>>
>> MultiXact member wraparound protections are now enabled
>>
>>
>> I tried enabling track_counts but it did not help.
>>
>
> Did you restart the server after making the change?
>
> Did Postgres start without the warnings previous to this?
>
>
>>
>> Any guidance is much appreciated here.
>>
>>
>> Thanks in Advance!
>>
>>
>>
>> --
>>
>> Regards,
>> Azim
>>
>>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>