On Fri, 2021-04-16 at 10:57 -0700, Moris Rumenov Vrachovski wrote:
> Thank you Laurenz! I have a second question. I downloaded postgreSQl 11.11 to
> upgrade from 11.2.
> I am having trouble upgrading postgresql, it is trying to install a new
> postgreSQL instead of upgrading.
A minor upgrade i
greg1457 writes:
> I migrated an postgresql instance from 9.5.4 to 9.5.21.
> Unaccent extension is installed in the database, in "application" schema.
> Since this migration, when i do a vaccumdb, i obtain an error :
> vacuumdb: vacuuming of database "application" failed: ERROR: function
> unac
Hi everyone,
I migrated an postgresql instance from 9.5.4 to 9.5.21.
Unaccent extension is installed in the database, in "application" schema.
Since this migration, when i do a vaccumdb, i obtain an error :
vacuumdb: vacuuming of database "application" failed: ERROR: function
unaccent(text) doe
I don't know anything about Sybase, but if that dump is something akin to
"pg_dump", then you are comparing apples and oranges.
Moreover, the base backup is compressed, and I don't know if the Sybase dump is.
If you had used PostgreSQL v13, you could check the backup for completenes. But
the be
t; size.
>
> For PostgreSQL we do backup with something like this cmd:
>
> pg_basebackup -U ${DBSUSER} -Ft -z -D ${BACKUPDIR}-${DATE}-${NUM}
>
> The resulting files
>
> # ls -lh backup-20210416-3
> insgesamt 999M
> -rw--- 1 postgres postgres 999M 16. Apr 14:02 ba
s cmd:
pg_basebackup -U ${DBSUSER} -Ft -z -D ${BACKUPDIR}-${DATE}-${NUM}
The resulting files
# ls -lh backup-20210416-3
insgesamt 999M
-rw--- 1 postgres postgres 999M 16. Apr 14:02 base.tar.gz
-rw--- 1 postgres postgres 17K 16. Apr 14:02 pg_wal.tar.gz
are less than 1 GByte.
Any ideas about the
On 14-04-2021 17:41, Tom Lane wrote:
Condor writes:
I try restore from old hard drive an database. The system is not
working, so I install new server, install postgres 9.0.3 and try to
copy
postgresql dir to new location but I receive error:
2021-04-14 11:47:04.205 UTC [10285] FATAL: data
