Re: How to restore roles without changing postgres password

Hi! Thank you. >pg_dumpall creates an SQL file which is just a simple text file >you can then edit sql removing postgres user from the file >This can be automated in a script that searches the generated sql file for the >postgres user replacing it with a blank/empty line or adds -- to the

Re: Function not imported in Entity Framework

Sir, I asked this in npgsql community who have developed *"EntityFramework6.Npgsql" , *link is : https://github.com/npgsql/npgsql/issues/948. and developer named *Shay Rojansky *aka *roji* has replied as below image: [image: @roji] On Tue, Feb 11, 2020 at 10:30 PM Adrian Klaver wrote: > On

Re: POLL: Adding transaction status to default psql prompt

+1 also. Thanks for the proposal. Anthony On Fri, Feb 7, 2020, 17:52 Kasun Kulathunga wrote: > On Thu, Feb 6, 2020, 20:29 Ken Tanzer wrote: > > Em qua, 5 de fev de 2020 às 23:55, Vik Fearing > escreveu: > > > Please answer +1 if you want or don't mind seeing transaction status by > default in

Re: Pre-version pg_upgrade syntax check

On Mon, 10 Feb 2020, Adrian Klaver wrote: So you already have 11 and 12 instances of Postgres running? Adrian, No. Both 11 and 12 are installed; neither is running. I have a cron job that runs pg_dumpall every weekday night. If so why use pg_upgrade? Because I wanted to try it rather

Re: Function not imported in Entity Framework

Thank you so much sir, but it didn't work for me as the database function in PostgreSQL and EntityFramework6.Npgsql is used as provider for entity framework. Thanks! Vikram On Thu, Feb 6, 2020 at 9:23 PM Adrian Klaver wrote: > On 2/6/20 1:36 AM, Vikram Sah wrote: > > Dear sir/mam, > > > > I

Re: Function not imported in Entity Framework

Got it sir, but unfortunately they have not provided any solution for the last 5 days. Thanks On Tue, 11 Feb 2020, 10:12 pm Adrian Klaver, wrote: > On 2/11/20 3:56 AM, Vikram Sah wrote: > > Thank you so much sir, but it didn't work for me as the database > > function in PostgreSQL and

Re: Pre-version pg_upgrade syntax check

On Tue, 11 Feb 2020, Rich Shepard wrote: So you already have 11 and 12 instances of Postgres running? Adrian, I just started 12.1 and, as user postgres, read last Friday's backup file. All's well. A final question: which conf file do I edit so when I enter 'psql -l' (or open a specific

Re: Function not imported in Entity Framework

On 2/11/20 8:35 AM, Vikram Sah wrote: Got it sir, but unfortunately they have not provided any solution for the last 5 days. Where have you asked besides here? Thanks On Tue, 11 Feb 2020, 10:12 pm Adrian Klaver, > wrote: On 2/11/20 3:56 AM, Vikram

Re: Pre-version pg_upgrade syntax check

On Tue, 11 Feb 2020, Adrian Klaver wrote: The above runs the psql client not the server. It is a way of determining what version binaries /usr/lib64/postgresql/11/bin/ actually contains. Adrian, Aha! Running the command taught me a couple of valuable lessons because both 11 and 12 show

Re: Function not imported in Entity Framework

On 2/11/20 3:56 AM, Vikram Sah wrote: Thank you so much sir, but it didn't work for me as the database function in PostgreSQL and EntityFramework6.Npgsql  is used as provider for entity framework. I have no idea where to go from here. Your best bet would be to reach out to the

Re: PostgreSQL Installer issue

Good morning Adrian, I believe your right. (Never did get a reply back from EDB when I brought this to their attention.) Cheers, George On 31/01/2020 2:38 p.m., Adrian Klaver wrote: On 1/31/20 12:27 PM, George Weaver wrote: Good afternoon, I am updating a PostgreSQL 10.3 installation to

Re: Pre-version pg_upgrade syntax check

On 2/11/20 5:43 AM, Rich Shepard wrote: On Mon, 10 Feb 2020, Adrian Klaver wrote: So you already have 11 and 12 instances of Postgres running? Adrian, No. Both 11 and 12 are installed; neither is running. I have a cron job that runs pg_dumpall every weekday night If so why use

Re: Pre-version pg_upgrade syntax check [FIXED]

On Tue, 11 Feb 2020, Rich Shepard wrote: A final question: which conf file do I edit so when I enter 'psql -l' (or open a specific database) I don't need to enter my password? I don't recall having to reset this permission with prior upgrades and want to do so now. Never mind: I found it:

Re: Pre-version pg_upgrade syntax check

On 2/11/20 9:00 AM, Rich Shepard wrote: On Tue, 11 Feb 2020, Adrian Klaver wrote: The above runs the psql client not the server. It is a way of determining what version binaries /usr/lib64/postgresql/11/bin/ actually contains. Adrian, Aha! Running the command taught me a couple of valuable

Re: Query returns no results until REINDEX

On Sun, Feb 9, 2020 at 12:50 PM Colin Adler wrote: > Looks like it found something. I checked out the contrib/pageinspect docs but > wasn't too sure what to run. Are incompatible libc versions causing btree > corruption something you consider a bug? If it's something you'd like to look > into

Re: Query returns no results until REINDEX

On Tue, Feb 11, 2020 at 8:33 PM Peter Geoghegan wrote: > > On Sun, Feb 9, 2020 at 12:50 PM Colin Adler wrote: > > Looks like it found something. I checked out the contrib/pageinspect docs > > but > > wasn't too sure what to run. Are incompatible libc versions causing btree > > corruption

Re: How to restore roles without changing postgres password

"Andrus" writes: > How to create backup script which restores all roles and role memberships > from other server without changing postgres user password. [ shrug... ] Edit the command(s) you don't want out of the script. This seems like a mighty random requirement to expect pg_dump to support

Re: How to restore roles without changing postgres password

HI Tom Not a bad idea, would want to extend this to all the roles on the server not just postgres I've edited the global dump many times removing/editing table spaces, comment old users, etc.. On Tue, Feb 11, 2020 at 5:46 PM Tom Lane wrote: > "Andrus" writes: > > How to create backup

JIT on Windows with Postgres 12.1

I am using the EDB Windows PG 12.1 installer and it seems not to have JIT enabled: C:\Program Files\PostgreSQL\12\bin>pg_config --configure --enable-thread-safety --enable-nls --with-ldap --with-openssl --with-ossp-uuid --with-libxml --with-libxslt --with-icu --with-tcl --with-perl --with-python

How to restore roles without changing postgres password

Hi! How to create backup script which restores all roles and role memberships from other server without changing postgres user password. I tried shell script PGHOST=example.com PGUSER=postgres PGPASSWORD=mypass export PGHOST PGPASSWORD PGUSER pg_dumpall --roles-only --file=globals.sql psql

Re: How to restore roles without changing postgres password

pg_dumpall creates an SQL file which is just a simple text file you can then edit sql removing postgres user from the file This can be automated in a script that searches the generated sql file for the postgres user replacing it with a blank/empty line or adds -- to the bringing of the line