Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110

Le 12/06/2020 à 00:40, Adrian Klaver a écrit : > On 6/11/20 1:30 PM, George Dimopoulos wrote: > Please reply to list also. > Ccing list. > >> Hi Adrian, >> >> Thank you very much for your help !!! >> I did the query, and I found out that >> SELECT DISTINCT c.SHAPE.SDO_GTYPE FROM NRM_CAVES.LOCATIONS

Re: suggestion: psql configs in .config

On 2020-Jun-11, Tom Lane wrote: > I'm finding it hard to see a compelling reason why that would be an > improvement. It would make psql randomly different from 95% of the > other programs that have similar config files. Or, if everybody > somehow got on board with "let's put config files in ~/.c

Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110

On 6/11/20 1:30 PM, George Dimopoulos wrote: Please reply to list also. Ccing list. Hi Adrian, Thank you very much for your help !!! I did the query, and I found out that SELECT DISTINCT c.SHAPE.SDO_GTYPE FROM NRM_CAVES.LOCATIONS c WHERE ROWNUM < 5

Re: suggestion: psql configs in .config

Caleb Cushing writes: > would it be possible to allow psql config files to reside in ~/.config/psql > to help unclutter ~ obviously this should be some kind of cascading lookup > first look for... e.g > .config/psql/psqlrc > .psqlrc I'm finding it hard to see a compelling reason why that would be

Re: suggestion: psql configs in .config

Got it. but... I guess I'm hoping this could be added to the default lookup path, no customization needed. On Thu, Jun 11, 2020 at 3:33 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thursday, June 11, 2020, Caleb Cushing wrote: > >> would it be possible to allow psql config file

Re: suggestion/question pgpass alias?

Thanks! On Thu, Jun 11, 2020 at 3:27 PM Alvaro Herrera wrote: > On 2020-Jun-11, Caleb Cushing wrote: > > > is it possible to support an alias for a pgpassfile? what I'm looking to > do > > is > > > > psql --alias company -h localhost > > > > and not type anything else and get a shell. if this i

Re: Something else about Redo Logs disappearing

On Thu, 2020-06-11 at 22:35 +0200, Magnus Hagander wrote: > I believe somebody around that time also wrote a set of bash scripts that can > be used in a pre/post-backup-job combination with the current APIs. https://github.com/cybertec-postgresql/safe-backup Yours, Laurenz Albe -- Cybertec | ht

Re: Something else about Redo Logs disappearing

On Thu, Jun 11, 2020 at 10:13 PM Peter wrote: > > Okay. So lets behave like professional people and figure how that > can be achieved: > At first, we drop that WAL requirement, because with WAL archiving > it is already guaranteed that an unbroken chain of WAL is always > present in the backup (e

Re: suggestion: psql configs in .config

On Thursday, June 11, 2020, Caleb Cushing wrote: > would it be possible to allow psql config files to reside in > ~/.config/psql to help unclutter ~ obviously this should be some kind of > cascading lookup > > first look for... e.g > .config/psql/psqlrc > .psqlrC > libpq consults environment var

suggestion: psql configs in .config

would it be possible to allow psql config files to reside in ~/.config/psql to help unclutter ~ obviously this should be some kind of cascading lookup first look for... e.g .config/psql/psqlrc .psqlrc or vice versa -- Caleb Cushing https://xenoterracide.com

Re: suggestion/question pgpass alias?

On 2020-Jun-11, Caleb Cushing wrote: > is it possible to support an alias for a pgpassfile? what I'm looking to do > is > > psql --alias company -h localhost > > and not type anything else and get a shell. if this is not possible could > this be added? I think what you want is a "service" file

suggestion/question pgpass alias?

is it possible to support an alias for a pgpassfile? what I'm looking to do is psql --alias company -h localhost and not type anything else and get a shell. if this is not possible could this be added? -- Caleb Cushing https://xenoterracide.com

Re: Something else about Redo Logs disappearing

Greetings, * Peter (p...@citylink.dinoex.sub.org) wrote: > On Wed, Jun 10, 2020 at 08:32:22AM -0400, Stephen Frost wrote: > ! > What repo?? I seem to have missed that at first glance. > ! > ! Yes, pgbackrest has a repo, like most other tools (though they call them > ! different things... pg_baseb

Re: Something else about Redo Logs disappearing

On Wed, Jun 10, 2020 at 08:32:22AM -0400, Stephen Frost wrote: ! > What repo?? I seem to have missed that at first glance. ! ! Yes, pgbackrest has a repo, like most other tools (though they call them ! different things... pg_basebackup has one though it's not really ! formal). ! ! > Are You inde

Re: ora2pg error : DBD::Oracle::db prepare failed: ORA-28110

On 6/11/20 12:32 PM, George Dimopoulos wrote: Hi Everyone, I am new to migrating oracle 18c EX to postgres. I do not know if this site is the correct site for my problem. If it is not, can you please point me to correct site to ask the question? I used ora2pg to start the migration but when

ora2pg error : DBD::Oracle::db prepare failed: ORA-28110

Hi Everyone, I am new to migrating oracle 18c EX to postgres. I do not know if this site is the correct site for my problem. If it is not, can you please point me to correct site to ask the question? I used ora2pg to start the migration but when I try to run " ora2pg -t SHOW_REPORT" I get the f

Re: table name

> On 11 Jun 2020, at 20:58, Paul Förster wrote: > > Hi Marc, > >> On 11. Jun, 2020, at 20:54, Marc Millas wrote: >> sorry if my question is tooo simple :-) > > it's not. :-) > >> obviously if I ask: >> select * from regions-20180101; >> I get a syntax error. >> if I try select * from $$regi

Re: table name

Hi Marc, > On 11. Jun, 2020, at 20:54, Marc Millas wrote: > sorry if my question is tooo simple :-) it's not. :-) > obviously if I ask: > select * from regions-20180101; > I get a syntax error. > if I try select * from $$regions_20180101$$; > I get another syntax error. > If I try to rename tha

Re: table name

damn.. thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Thu, Jun 11, 2020 at 8:55 PM Paul Ramsey wrote: > ALTER TABLE "regions-20180101" rename to regions_20180101; > > > > On Jun 11, 2020, at 11:54 AM, Marc Millas > wrote: > > > > sorry if my question is tooo simple :-) >

Re: table name

ALTER TABLE "regions-20180101" rename to regions_20180101; > On Jun 11, 2020, at 11:54 AM, Marc Millas wrote: > > sorry if my question is tooo simple :-) > > I got a shapefile from the french gov. > I import it with postgis 3.01 utility. > fine ! > the table created by this utility is named re

table name

sorry if my question is tooo simple :-) I got a shapefile from the french gov. I import it with postgis 3.01 utility. fine ! the table created by this utility is named regions-20180101 with the dash in the middle. I see that table name in pg_class, and, also, in the geometry_columns view. obviou

ansible modules for postgresql installation/config

it looks like there are a number of roles available through ansible galaxy that support initial postgresql setup and configuration. i'm wondering if there are any that are more popular/capable that i should consider vs just picking a few and evaluating those. does anyone have any recommendations?

Re: CPU Configuration - postgres

> For parallelism, there are these options That only matters if you want to use those extra cores to make individual queries / commands faster. If all OP cares about is "will PG use my extra cores", the answer is yes it will without doing anything special.

Re: CPU Configuration - postgres

Hi, > On 11. Jun 2020, at 10:24, Sujith Kumar.S wrote: > > Is there any configuration in postgresql that restrict the number of CPU > usage by postgres process. For parallelism, there are these options: - max_parallel_workers_per_gather - max_parallel_workers - max_worker_processes Where the

Re: pgbouncer logrotate found error, skipping

On 6/11/20 1:47 AM, pgdba pgdba wrote: Hello , When I want to create a logrotate in postgresql, I get this error when I want to work later. Does anyone have any idea about this error? logrotate -f /etc/logrotate.conf error after error: pgbouncer: 1 unknown option 'var' - ignoring line error: p

Re: CPU Configuration - postgres

On 6/11/20 1:24 AM, Sujith Kumar.S wrote: Hi Team, Could you please confirm whether I need to restart my postgresql instance after adding CPU to my server. You did that while it was running? Is there any configuration in postgresql that restrict the number of CPU usage by postgres process

Re: Something else about Redo Logs disappearing

On Wed, Jun 10, 2020 at 01:10:36PM +0200, Magnus Hagander wrote: ! > Just having a look at their webpage, something seems to have been updated ! > recently, they now state that they have a new postgres adapter: ! > ! > https://www.bareos.com/en/company_news/postgres-plugin-en1.html ! > Enjoy readi

pgbouncer logrotate found error, skipping

Hello , When I want to create a logrotate in postgresql, I get this error when I want to work later. Does anyone have any idea about this error? logrotate -f /etc/logrotate.conf error after error: pgbouncer: 1 unknown option 'var' - ignoring line error: pgbouncer: 11 unknown unit 'm' error: found

CPU Configuration - postgres

Hi Team, Could you please confirm whether I need to restart my postgresql instance after adding CPU to my server. Is there any configuration in postgresql that restrict the number of CPU usage by postgres process.

Re: Changing from security definer to security invoker without dropping ?

čt 11. 6. 2020 v 9:51 odesílatel Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> napsal: > > > > Sent with ProtonMail Secure Email. > > ‐‐‐ Original Message ‐‐‐ > On Thursday, 11 June 2020 08:39, Pavel Stehule > wrote: > > Hi > > čt 11. 6. 2020 v 9:29 odesílatel

Re: Changing from security definer to security invoker without dropping ?

Sent with ProtonMail Secure Email. ‐‐‐ Original Message ‐‐‐ On Thursday, 11 June 2020 08:39, Pavel Stehule wrote: > Hi > > čt 11. 6. 2020 v 9:29 odesílatel Laura Smith > napsal: > > > Hi, > > > > Just curious if there is a way to switch a function from definer to invoker > > witho

Re: Changing from security definer to security invoker without dropping ?

Hi čt 11. 6. 2020 v 9:29 odesílatel Laura Smith < n5d9xq3ti233xiyif...@protonmail.ch> napsal: > Hi, > > Just curious if there is a way to switch a function from definer to > invoker without dropping ? > create function foo(a int) returns int as $$ begin return $1; end $$ language plpgsql; postg

Changing from security definer to security invoker without dropping ?

Hi, Just curious if there is a way to switch a function from definer to invoker without dropping ? We're working on improving the security posture by changing functions from definer to invoker, but I'm wondering what the best way to roll this out to production is given that dropping and re-cre

Re: Parallel safety of contrib extensions

On Wed, Jun 10, 2020 at 12:40:54PM -0400, Tom Lane wrote: > "Winfield, Steven" writes: >> There was a thread about this back in 2016[1], but I've just been >> bitten by it and wondered if any (more) extensions, particularly >> btree_gist, will have their operators/functions verified and marked as