How to correctly enable Postgresql on ubuntu 16.04 - Ask Ubuntu


i installed psql (postgresql) 9.6.1. when type 

psql

i got:

 psql: not connect server: no such file or directory     server running locally , accepting     connections on unix domain socket "/var/run/postgresql/.s.pgsql.5432"?

when type 

netstat -ln

i got following:

  active internet connections (only servers) proto recv-q send-q local address           foreign address         state       tcp        0      0 0.0.0.0:17500           0.0.0.0:*               listen      tcp        0      0 127.0.0.1:17600         0.0.0.0:*               listen      tcp        0      0 127.0.0.1:17603         0.0.0.0:*               listen      tcp        0      0 127.0.1.1:53            0.0.0.0:*               listen      tcp6       0      0 :::10137                :::*                    listen      tcp6       0      0 :::17500                :::*                    listen      tcp6       0      0 127.0.0.1:8005          :::*                    listen      tcp6       0      0 :::9000                 :::*                    listen      tcp6       0      0 :::20080                :::*                    listen      tcp6       0      0 :::8080                 :::*                    listen      tcp6       0      0 :::80                   :::*                    listen      udp        0      0 0.0.0.0:17500           0.0.0.0:*                           udp        0      0 0.0.0.0:5353            0.0.0.0:*                           udp        0      0 0.0.0.0:5353            0.0.0.0:*                           udp        0      0 0.0.0.0:5353            0.0.0.0:*                           udp        0      0 0.0.0.0:39111           0.0.0.0:*                           udp        0      0 127.0.1.1:53            0.0.0.0:*                           udp        0      0 0.0.0.0:68              0.0.0.0:*                           udp        0      0 0.0.0.0:631             0.0.0.0:*                           udp6       0      0 :::5353                 :::*                                udp6       0      0 :::5353                 :::*                                udp6       0      0 :::56552                :::*                                raw6       0      0 :::58                   :::*                    7

showing got no 5432 port available. tried using this answer got nothing. tried same method using postgres 9.4 , 9.6 got nothing different too. has tips solve this? in advance.

unfortunately didn't manage accomplish this. way out installing compiling binaries , on. method worked


Comments

Post a Comment

Popular posts from this blog

download - Firefox cannot save files (most of the time), how to solve? - Super User

this not full duplicate of this question or this question , though base question same. however, questions have no answers. for on half year have problems downloading files firefox. when click on download link, download dialog opened asking me do, save or open it. immediately, there error/warning pop-up (twice, can see 1 @ first) ok button. looks this message : "c:\users\%user%\appdata\local\temp\wbbdv9k8.zip.part not saved because source file not read. try again later or contact server administrator." replace '%user%' name of user trying download. after closing pop-up, download dialog disappears , have minimize firefox , open again, see other pop-up. downloading exact same file internet explorer work, not desired. i tried solutions here . tried solutions here . tried disabling extensions. tried fixing permissions on temp folder. tried making files , folder in profile directory non-readonly. tried running firefox administrator. tried
Read more

windows - "-2146893807 NTE_NOT_FOUND" when repair certificate store - Super User

i try repair certificate store in windows 10 doing c:\windows\system32>certutil -store -user ‎330000019dba8d5dddb98062a900000000019d "personal" certutil: -store command failed: 0x80090011 (-2146893807 nte_not_found) certutil: object not found. i have double check mmc, certificate details serial number of certificate. still fail repair certificate store. can please help? i getting same error when trying export pfx. turns out had export c:\cert.pfx instead of cert.pfx (it trying export file cert store ( cert:\localmachine\my ).
Read more

sql server - "Configuration file does not exist", Event ID 274 - Super User

sql server 2014 standard in server 2012 r2 i installed sql server 2014 in drive d: i following error: microsoft ssis service: registry setting specifying configuration file not exist. attempting load default config file. simply add c:\program files\microsoft sql server\1?0\dts\binn\msdtssrvr.ini.xml to default reg_sz value in: hkey_local_machine\software\microsoft\microsoft sql server\1?0\ssis\serviceconfigfile where ? replaced matching sql server version
Read more