Hi PostgresSQL Support,
I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest best
solution for doing the migration.
Regards
H.Kumar
Hi,
I think you can start from:
- https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion
-
https://severalnines.com/blog/migrating-oracle-postgresql-what-you-should-know
- http://ora2pg.darold.net/
- https://pgxn.org/dist/orafce/
Regards,
Enrico
Il 26/06/2019 15:42, Hitesh Chadd
i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2.
everything goes fine and server is up and running. but trying to
INSERT/UPDATE anything, server crashes:
=# select id from user where id=0;
id
0(1 row)=# UPDATE user SET is_deleted = true WHERE id = 0;
psql: server c
Hi Team,
I done the installation using yum poostgresql 11 server method now i need
to update or apply the patch using repo file how to do this 11.2 to 11.4
please share me the steps .
--
Thanks,
Prakash.R
On Wed, Jun 26, 2019 at 5:06 PM Jesper Pedersen
wrote:
> Hi,
>
> PostgreSQL 11.4
>
> Given,
>
> postgresql.conf:
>
> wal_level = replica
> synchronous_commit = remote_apply
> synchronous_standby_names = '*'
>
>
> CREATE ROLE repluser WITH LOGIN REPLICATION PASSWORD 'mypwd';
> SEL
Hi Magnus,
On 6/27/19 8:37 AM, Magnus Hagander wrote:
What am I missing here ?
I believe your problem is remote_apply.
pg_receivewal never *applies* any WAL, so it just updates the write and
flush locations. Notice how the replay_lsn remains NULL.
So you need synchronous_commit to be 'on' o
On Wed, 26 Jun 2019 19:12:07 +0530
Hitesh Chadda wrote:
> Hi PostgresSQL Support,
>
> I have to migrate from Oracle 11g to PostgresSQL 11.4. Please suggest
> best solution for doing the migration.
Bit of a broad topic for an answer. Other than "carefully", there
isn't enough of a question to an
Em qui, 27 de jun de 2019 às 05:35, Prakash Ramakrishnan <
prakash.ramakrishnan...@nielsen.com> escreveu:
> Hi Team,
>
> I done the installation using yum poostgresql 11 server method now i need
> to update or apply the patch using repo file how to do this 11.2 to 11.4
> please share me the steps
Thanks for your support.
On Thu, Jun 27, 2019, 18:58 Fabrízio de Royes Mello
wrote:
>
> Em qui, 27 de jun de 2019 às 05:35, Prakash Ramakrishnan <
> prakash.ramakrishnan...@nielsen.com> escreveu:
>
>> Hi Team,
>>
>> I done the installation using yum poostgresql 11 server method now i need
>> to
Our company is looking for commercial training in postgresql. We want a
training option that's as in-depth as possible (going as far as being able
to read and patch postgresql source code). Is there any company that offers
something like that?
Another important thing to mention is that due to lega
Em qui, 27 de jun de 2019 às 10:47, Marcelo Lacerda <
marceloslace...@gmail.com> escreveu:
> Our company is looking for commercial training in postgresql. We want a
> training option that's as in-depth as possible (going as far as being able
> to read and patch postgresql source code). Is there an
Hi,
Got this issue again.
Settings on the platform (PG 9.6.11):
max_pred_locks_per_transaction = 3000
max_connections = 800
Despite the fact that documentation says:
> with the exception of fast-path locks, each lock manager will deliver a
consistent set of results
I've noticed the following:
1.
On Thu, Jun 27, 2019 at 1:28 AM Mohsen Bande wrote:
> i have a working database in PG 12 Beta 1. today i upgraded it to Beta 2.
> everything goes fine and server is up and running. but trying to
> INSERT/UPDATE anything, server crashes:
Is it possible for you to send us a stacktrace?
https://w
Hi,
I am running into a strange issue with Postgres 10 when using pg_dump with
the directory format and jobs parameter set it intermittently hangs. Seems
to occur less frequently the lower I set the jobs parameter but does happen
eventually even when set to 2 (could not reproduce when jobs=1). I
Ben Snaidero writes:
> I am running into a strange issue with Postgres 10 when using pg_dump with
> the directory format and jobs parameter set it intermittently hangs. Seems
> to occur less frequently the lower I set the jobs parameter but does happen
> eventually even when set to 2 (could not r
On Thu, Jun 27, 2019 at 2:34 PM Tom Lane wrote:
> Ben Snaidero writes:
> > I am running into a strange issue with Postgres 10 when using pg_dump
> with
> > the directory format and jobs parameter set it intermittently hangs.
> Seems
> > to occur less frequently the lower I set the jobs parameter
Ben Snaidero writes:
> Do these stack traces shed help at all?
None worth mentioning :-(. Can you rebuild with debug symbols?
regards, tom lane
On 6/26/19 7:28 AM, David Gauthier wrote:
Ccing list.
Actually, I'm not storing 4 records in the 'grades' table for each
record in the 'students' table. For example, if student Joe gets
straight A's, he points to grades.grade_id = 1. If student Sue also
gets straight A's, she points to grade
Hi Fabrizo,
After applying the update command getting this error ,
postg...@shacoyuhss001.enterprisenet.org:/home/postgres
==> psql
psql (11.4, server 11.3)
Type "help" for help.
postgres=#
postgres=# select version();
version
On Wed, Jun 26, 2019 at 02:08:19PM -0400, Brad Nicholson wrote:
> In testing, it doesn't appear to matter. I've ensured that I've generated
> some full page writes (confirmed via pg_waldump), and those apply
> fine.
Full pages writes are first written from shared buffers to WAL, where
their check
Hello All,
How the Auto vacuum works on logical partition tables in PostgreSQL 11.
Currently, we are using database in PG10 with logical partition of tables
and we are facing an performance issue due to large number of bloats.
Actually we have notice that Auto vacuum in PG10 keeps vacuuming the
21 matches
Mail list logo
