Hi, Adrian
Thanks in advance.
pdgump command:
pg_dump -U myuser -Fc -Z3 -d mydb > dbdump.backup
I'm not sure which pg_dump version did i use before, but I used psql 12.5 to
dump and the db version is postgresql 9.6.
pgrestore command:
pg_restore -U myuser -j8 -d mydb dbdump.backup
I’ve tried
Hi, Adrian
Thanks in advance.
pdgump command:
pg_dump -U myuser -Fc -Z3 -d mydb > dbdump.backup
I'm not sure which pg_dump version did i use before, but I used psql 12.5 to
dump and the db version is postgresql 9.6.
pgrestore command:
pg_restore -U myuser -j8 -d mydb dbdump.backup
I’ve tried
On 8/2/21 6:42 PM, Gilar Ginanjar wrote:
Hi,
I have a db dump (.backup) that i want to restore. But it comes up with error:
"found unexpected block ID when reading data"
Is there any chance i can save my backup? The problem is I don't have the
database anymore.
I used psql 12.5 when dumping
Hi,
I have a db dump (.backup) that i want to restore. But it comes up with error:
"found unexpected block ID when reading data"
Is there any chance i can save my backup? The problem is I don't have the
database anymore.
I used psql 12.5 when dumping the database approx a year ago.
Mladen Gogala writes:
> The query from the view would probably merge view with the original and
> optimize everything as a single query. Unfortunately, there is no way to
> tell:
> mgogala=# explain select ename,job,sal from acct_view;
> QUERY PLAN
> -
For all that we know, it may already be happening. That looks like a
pretty reasonable optimization which may already be in place. If we
create a view:
mgogala=# select * from dept;
deptno | dname | loc
++--
10 | ACCOUNTING | NEW YORK
20 | RESEARCH
On 8/2/21 2:14 PM, Vikas Sharma wrote:
Dear Experts,
Could you please share some real life examples of using pgcrypto in
production?
I am planning to use it in our environment and wondering what could be
the best practice for its use.
I would start by doing a search on 'using pgcrypto', th
After upgrading from PostgreSQL 9.6 to 13 we started to experience
locking issues once per week or two.
This turned out to be a performance problem and reused pid-s. No
deadlock.
Dear Experts,
Could you please share some real life examples of using pgcrypto in
production?
I am planning to use it in our environment and wondering what could be the
best practice for its use.
Thank you. Regards
Vikas S
On Mon, Aug 2, 2021 at 12:20 PM Dhanush D wrote:
> It doesn't show up twice based on these checks (Is there any other way I
> can check if the seq is showing up twice?).
>
>
SELECT * FROM pg_class WHERE relkind = 'S' AND relname ~ 'permission';
I made the "relname" a bit broad, you should see t
On Mon, Aug 2, 2021 at 11:42 AM Dhanush D wrote:
> Multiple "Create sequence" and "Drop sequence". However the drop sequence
> doesn't seem to drop the sequence cleanly hence failing the restore process.
>
It shouldn't be dropping at all - it assumes it is starting from an empty
slate.
Same que
Ok, thanks guys. Let me check that.
On Sun, Aug 1, 2021 at 10:05 PM Tom Lane wrote:
> Adrian Klaver writes:
> > In that vein the OP could run:
>
> > DO $$
> > import sys
> > plpy.notice(sys.version)
> > $$ LANGUAGE plpython3u;
>
> > in the database to see what plpython3u is actually p
On Mon, 2 Aug 2021 at 19:53, Tom Lane wrote:
> Avi Weinberg writes:
> > Is there a way to compute a column in a view only if it is referenced in
> the query? I have a view's column that its value is computed by a
> function. If in the query that column is not used at all, can Postgres
> "skip"
Avi Weinberg writes:
> Is there a way to compute a column in a view only if it is referenced in the
> query? I have a view's column that its value is computed by a function. If
> in the query that column is not used at all, can Postgres "skip" computing it?
If the function is not volatile, an
Hi,
Is there a way to compute a column in a view only if it is referenced in the
query? I have a view's column that its value is computed by a function. If in
the query that column is not used at all, can Postgres "skip" computing it?
Thanks!
IMPORTANT - This email and any attachments is inte
On Sunday, August 1, 2021, obi reddy wrote:
> Hello everyone, I want to schedule the automatic backup in windows
> postgresql platform.
>
> I have attached the script, if any changes is required please correct and
> send back. This is my humble request.
> Actually I don't know to write the wind
16 matches
Mail list logo
