Password encryption

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

Re: postgres started without auto vaccum

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 st

Re: postgres started without auto vaccum

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 aft

postgres started without auto vaccum

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

postgres not starting

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 /

Re: initdb execution

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

initdb execution

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 i

LDAP for postgres

hello, Any idea about how I can enable LDAP for postgres after install ? -- Regards, Azim

Re: Fwd: postgres instalation

eing 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 su

Re: Fwd: postgres instalation

ain > 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/2

Re: Fwd: postgres instalation

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

Fwd: postgres instalation

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

Postgres install

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 in

Re: postgres for production

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

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

Re: Sync replication

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 >

Sync replication

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: Postgres for hadoop

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 Moha

Postgres for hadoop

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 HA

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

Postgres HA

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 prima

Production Database requirement

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 re

Oracle to postgres migration

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

Oacle to Postgres migration

Hello, Can anyone suggest me -- Regards, Azim Virus-free. www.avast.com