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:

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

Why is Zod so slow?

Zod’s flexibility comes at a cost. This article breaks down why Zod is slower than AOT-compiled validators like Typia, and how to fix it with a build-time optimization that brings production-grade performance.

Ikeh Akinyemi
Oct 16, 2025 ⋅ 5 min read
the replay oct 15 graphic

The Replay (10/15/25): AI’s accessibility problem, React 19.2, and more

Discover what’s new in The Replay, LogRocket’s newsletter for dev and engineering leaders, in the October 15th issue.

Matt MacCormack
Oct 15, 2025 ⋅ 34 sec 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

Hey there, want to help make our blog better?

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