Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory

[hmidi slim]

I didn't find the file pg_similarity.control when I run find / -name
'pg_similarity.control' 2> /dev/null

Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory

[Adrian Klaver]

On 03/17/2018 03:03 AM, hmidi slim wrote:
I didn't find the file pg_similarity.control when I run find / -name 
'pg_similarity.control' 2> /dev/null


In your original post you use the file from pgFoundry:

pgfoundry.org/frs/download.php/2237/pg_similarity-0.0.19.tgz

When I installed from that file I got:

/usr/bin/mkdir -p '/usr/local/pgsql10/lib64'
/usr/bin/mkdir -p '/usr/local/pgsql10/share/contrib'
/usr/bin/install -c -m 755  pg_similarity.so 
'/usr/local/pgsql10/lib64/pg_similarity.so'
/usr/bin/install -c -m 644 .//uninstall_pg_similarity.sql 
pg_similarity.sql '/usr/local/pgsql10/share/contrib/'


Note no pg_similarity.control and also it did not install to 
~/share/extension but to ~/share/contrib.


From here:

https://github.com/eulerto/pg_similarity

The latest version is 1.0 not 0.0.19. I did:

git clone https://github.com/eulerto/pg_similarity.git

and then ran the make process and got:

/usr/bin/mkdir -p '/usr/local/pgsql10/lib64'
/usr/bin/mkdir -p '/usr/local/pgsql10/share/extension'
/usr/bin/mkdir -p '/usr/local/pgsql10/share/extension'
/usr/bin/install -c -m 755  pg_similarity.so 
'/usr/local/pgsql10/lib64/pg_similarity.so'
/usr/bin/install -c -m 644 .//pg_similarity.control 
'/usr/local/pgsql10/share/extension/'
/usr/bin/install -c -m 644 .//pg_similarity--1.0.sql 
.//pg_similarity--unpackaged--1.0.sql pg_similarity.sql 
'/usr/local/pgsql10/share/extension/'



The pg_similarity.control was installed and the extension was installed 
in ~/share/extension.


More importantly I could CREATE the extension:

test=# CREATE EXTENSION pg_similarity;
CREATE EXTENSION




--
Adrian Klaver
adrian.kla...@aklaver.com

Re: What is the meaning of pg_restore output?

[Alexandru Lazarev]

Hi All, Thanks for your replies.
What about "item" key-word - is it appearing only when -j > 1?

Other phrases "pg_restore: processing *item *3615 DEFAULT id
pg_restore: creating DEFAULT "public.id"
are observed if pg_restore is executed with flag -j N (where N > 1)
and aren't present when -j 1 (or without -j)


2. Are they (output phrases) documented somewhere?


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Thu, Mar 8, 2018 at 11:32 PM, Tom Lane  wrote:

> Adrian Klaver  writes:
> > When I restore using 10.2 I see:
> > pg_restore: creating ACL "public.TABLE wl_week"
> > Do you see something similar?
>
> > My suspicion is that this might have something to do with the commits
> below:
>
> Yeah, this evidently changed in commits 3eb9a5e7c et al, which made ACL
> restore go through restore_toc_entry().  I think I figured that the
> "creating ACL" message that restore_toc_entry() would emit made the
> dedicated "setting owner and privileges" message redundant.  It had also
> been misleading for quite some time, maybe forever: restore of that TOC
> entry would set the object's privileges all right, but if it ever had
> anything to do with setting the object's ownership, it was a really long
> time ago.
>
> regards, tom lane
>

changing my mail address

[wambacher]

Hi,

how can i change my mail adress for the postgresql mailing lists? adding 
my new address worked, but how do i get rid of the old one?


regards

walter

Re: changing my mail address

[Stephen Frost]

Greetings,

* wambac...@posteo.de (wambac...@posteo.de) wrote:
> how can i change my mail adress for the postgresql mailing lists? adding my
> new address worked, but how do i get rid of the old one?

You'll need to change it on postgresql.org:

https://www.postgresql.org/account/

Once you've done that, log out of all PG sites (possibly by deleteing
cookies which you may have from them) and then log into postgresql.org
first and then go to lists.postgresql.org and the update should be
passed through.

Thanks!

Stephen


signature.asc
Description: PGP signature

Re: changing my mail address

[wambacher]

thanks, got it.

walter


Am 17.03.2018 um 16:51 schrieb Stephen Frost:

Greetings,

* wambac...@posteo.de (wambac...@posteo.de) wrote:

how can i change my mail adress for the postgresql mailing lists? adding my
new address worked, but how do i get rid of the old one?

You'll need to change it on postgresql.org:

https://www.postgresql.org/account/

Once you've done that, log out of all PG sites (possibly by deleteing
cookies which you may have from them) and then log into postgresql.org
first and then go to lists.postgresql.org and the update should be
passed through.

Thanks!

Stephen


--
[url=http://t1p.de/epnc]Emergency Map[/url], 
[url=http://t1p.de/t7xy]PLZ-Karte[/url], [url=http://t1p.de/d6hv]Fools[/url], 
[url=http://t1p.de/6ptd]Boundaries Map[/url], [url=http://t1p.de/huxb]Postcode 
Boundaries[/url], [url=http://t1p.de/mita]Missing Boundaries[/url], 
[url=http://t1p.de/0llz]@wambacher1[/url]

Re: What is the meaning of pg_restore output?

[Adrian Klaver]

On 03/17/2018 07:30 AM, Alexandru Lazarev wrote:

Hi All, Thanks for your replies.
What about "item" key-word - is it appearing only when -j > 1?

Other phrases "pg_restore: processing /*item */3615 DEFAULT id
pg_restore: creating DEFAULT "public.id "
are observed if pg_restore is executed with flag -j N (where N > 1)
and aren't present when -j 1 (or without -j)


2. Are they (output phrases) documented somewhere?


Grepping source in src/bin/pg_dump/:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/pg_dump/pg_backup_archiver.c;h=8892b177905ea81b58ddbc728fd46d47e2d017c6;hb=65c6b53991e1c56f6a0700ae26928962ddf2b9fe

if (do_now)
   {
 /* OK, restore the item and update its dependencies */
 ahlog(AH, 1, "processing item %d %s %s\n",
   next_work_item->dumpId,
   next_work_item->desc, next_work_item->tag);

Which is in section with this comment:

/*
 * Main engine for parallel restore.
 *
 * Parallel restore is done in three phases.  In this first phase,
 * we'll process all SECTION_PRE_DATA TOC entries that are allowed to be
 * processed in the RESTORE_PASS_MAIN pass.  (In practice, that's all
 * PRE_DATA items other than ACLs.)  Entries we can't process now are
 * added to the pending_list for later phases to deal with.
 */


--
Adrian Klaver
adrian.kla...@aklaver.com

Re: changing my mail address

[Ron Johnson]

On 03/17/2018 10:51 AM, Stephen Frost wrote:

Greetings,

* wambac...@posteo.de (wambac...@posteo.de) wrote:

how can i change my mail adress for the postgresql mailing lists? adding my
new address worked, but how do i get rid of the old one?

You'll need to change it on postgresql.org:

https://www.postgresql.org/account/

Once you've done that, log out of all PG sites (possibly by deleteing
cookies which you may have from them) and then log into postgresql.org
first and then go to lists.postgresql.org and the update should be
passed through.

Sadly, https://www.postgresql.org/account/reset/ hasn't worked for me in yearss.

--
Angular momentum makes the world go 'round.

Re: changing my mail address

[Michelle Konzack]

Am DATE hackte AUTHOR in die Tasten: wambac...@posteo.de
> Hi,
>
> how can i change my mail adress for the postgresql mailing lists?
> adding
> my new address worked, but how do i get rid of the old one?

Useing the List-Unsubscribe header from The Mailinglist?

> regards
>
> walter


-- 
Michelle KonzackMiila ITSystems @ TDnet
GNU/Linux Developer 00372-54541400

Re: changing my mail address

[Stephen Frost]

Greetings,

* Ron Johnson (ron.l.john...@cox.net) wrote:
> On 03/17/2018 10:51 AM, Stephen Frost wrote:
> >Once you've done that, log out of all PG sites (possibly by deleteing
> >cookies which you may have from them) and then log into postgresql.org
> >first and then go to lists.postgresql.org and the update should be
> >passed through.
>
> Sadly, https://www.postgresql.org/account/reset/ hasn't worked for me in 
> yearss.

That wasn't what the OP was asking about, but if you're having an issue
there, then please explain exactly what you're trying to do and what
issue you're seeing.  We're happy to try and resolve any such issues.

Thanks!

Stephen


signature.asc
Description: PGP signature

Re: changing my mail address

[Ron Johnson]

On 03/17/2018 01:08 PM, Stephen Frost wrote:

Greetings,

* Ron Johnson (ron.l.john...@cox.net) wrote:

On 03/17/2018 10:51 AM, Stephen Frost wrote:

Once you've done that, log out of all PG sites (possibly by deleteing
cookies which you may have from them) and then log into postgresql.org
first and then go to lists.postgresql.org and the update should be
passed through.

Sadly, https://www.postgresql.org/account/reset/ hasn't worked for me in yearss.

That wasn't what the OP was asking about, but if you're having an issue
there, then please explain exactly what you're trying to do and what
issue you're seeing.  We're happy to try and resolve any such issues.


Having https://www.postgresql.org/account/reset/ send an password email to 
the address where I receive list emails hasn't worked for me in years.  
(Yes, I looked in the Spam folder, and the Inbox, and the folder where 
-general emails are filtered to.)


When I'd stopped using PG for a while, the simplest solution was to send 
them to the Trash.



--
Angular momentum makes the world go 'round.

Re: changing my mail address

[Adrian Klaver]

On 03/17/2018 11:31 AM, Ron Johnson wrote:

On 03/17/2018 01:08 PM, Stephen Frost wrote:

Greetings,

* Ron Johnson (ron.l.john...@cox.net) wrote:

On 03/17/2018 10:51 AM, Stephen Frost wrote:

Once you've done that, log out of all PG sites (possibly by deleteing
cookies which you may have from them) and then log into postgresql.org
first and then go to lists.postgresql.org and the update should be
passed through.
Sadly, https://www.postgresql.org/account/reset/ hasn't worked for me 
in yearss.

That wasn't what the OP was asking about, but if you're having an issue
there, then please explain exactly what you're trying to do and what
issue you're seeing.  We're happy to try and resolve any such issues.


Having https://www.postgresql.org/account/reset/ send an password email 
to the address where I receive list emails hasn't worked for me in 
years. (Yes, I looked in the Spam folder, and the Inbox, and the folder 
where -general emails are filtered to.)


I just tried it and it worked for me:

"You are receiving this e-mail because you requested a password reset 
for your

PostgreSQL community account.

Please go to the following page and choose a new password:

https://www.postgresql.org/account/reset/ODIzMA-4uk-1d498cb7a2655b5e69ac/

Your username, in case you've forgotten, is aklaver.

"



When I'd stopped using PG for a while, the simplest solution was to send 
them to the Trash.






--
Adrian Klaver
adrian.kla...@aklaver.com