2020-04-10
953
#postgresql
Michael Okoh
16741
Apr 10, 2020 ⋅ 3 min read

Setting up a remote Postgres database server on Ubuntu 18.04

Michael Okoh I code, that's all.

Recent posts:

Goodbye, useState? Smarter state modeling for modern React apps

Goodbye, useState? Smarter state modeling for modern React apps

Ever opened a React file and found a graveyard of useState hooks? The problem isn’t React; it’s how we model state. Here’s how to do it smarter.

Oscar Jite-Orimiono
Oct 21, 2025 ⋅ 9 min read

Why third-party integrations break in React 19 — And how to future-proof them

React 19 breaks old third-party integrations. Learn why concurrent rendering exposes brittle SDKs and how to rebuild them with resilient modern patterns.

Peter Aideloje
Oct 20, 2025 ⋅ 4 min read
React useEffectEvent: Goodbye to stale closure headaches

React useEffectEvent: Goodbye to stale closure headaches

Discover why the useEffectEvent Hook is important, how to use it effectively, and how it compares to useRef.

David Omotayo
Oct 17, 2025 ⋅ 5 min read
I Tried Shadcn CLI 3.0 — Here’s What I Learned

I tried Shadcn CLI 3.0 — here’s what I learned

Shadcn CLI 3.0 takes component management to a new level. With namespaced registries, private access, and AI-powered discovery, it’s now faster and smarter to build React UIs.

Emmanuel John
Oct 17, 2025 ⋅ 6 min read
View all posts

5 Replies to "Setting up a remote Postgres database server on Ubuntu 18.04"

  1. su – postgres ask for password but i have not filled any password during the installation process.
    can you please assist on this issue.
    thnak you

  2. Hi Hariom, I opened another terminal instance with my user and I wrote there “sudo passwd postgresql” command. As it is my user, I could change postgres user password.
    After that I went back to su – posgres terminal and went on from that point.

  3. Nice tutorial! i was struggling in the part to open the port where it kept asking for a postgres password, i just needed to ‘exit’ from there i could run the command

Leave a Reply

Would you be interested in joining LogRocket's developer community?

Join LogRocket’s Content Advisory Board. You’ll help inform the type of content we create and get access to exclusive meetups, social accreditation, and swag.

Sign up now