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 !
On 6/15/25 08:15, Adrian Klaver wrote:
On 6/15/25 01:06, Rachel Roch wrote:
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. ;-)
Don't think so, the -F is redundant.
It is redundant for
On 6/15/25 01:06, Rachel Roch wrote:
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. ;-)
Don't think so, the -F is redundant.
Try grep -F then fgrep and then fgrep -F on the same file.
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
On 6/14/25 01:42, Rachel Roch wrote:
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 int
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
On 6/13/25 11:23, Tom Lane wrote:
Rachel Roch writes:
This is the error I am seeing:
pg_restore: error: could not execute query: ERROR: permission denied to change default privilegesCommand
was: ALTER DEFAULT PRIVILEGES FOR ROLE "postgres" IN SCHEMA "public" GRANT SELECT ON
TABLES TO "my_dat
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
Rachel Roch writes:
> This is the error I am seeing:
> pg_restore: error: could not execute query: ERROR: permission denied to
> change default privilegesCommand was: ALTER DEFAULT PRIVILEGES FOR ROLE
> "postgres" IN SCHEMA "public" GRANT SELECT ON TABLES TO "my_database_ro";
Well, you aren't
