15 Jun 2025, 17:15 by adrian.kla...@aklaver.com:
>
> It is redundant for fgrep.
>
Talk about muscle memory ! How many years have I still been typing fgrep -F
thinking I was typing grep -F !
14 Jun 2025, 16:21 by adrian.kla...@aklaver.com:
>
> Isn't fgrep -F redundant? As I understand it fgrep = grep -F
>
You have the wrong end of the stick. ;-)
As per Grep 3.8 release notes
(https://lists.gnu.org/archive/html/info-gnu/2022-09/msg1.html):
"The egrep and fgrep commands, whic
13 Jun 2025, 20:13 by adrian.kla...@aklaver.com:
>
> To get at an editable script you can do something like:
>
> pg_restore -f my_database_txt.sql my_database.dump
>
> This will give you a plain text version of the dump that you can feed back to
> psql to load into remote database.
>
Thanks
I have a pg_dump from a postgres instance that I am attempting to restore onto
a cloud one (i.e. an instance where I don't have access to the postgres
superuser)
The dump was taken with:
pg_dump -Fc --quote-all-identifiers --serializable-deferrable
--no-unlogged-table-data my_database > my_dat
