Re: [GENERAL] pg_restore --clean failing due to dependancies

2016-11-15 Thread Adrian Klaver
On 11/15/2016 07:55 AM, Arnaud L. wrote: Le 15/11/2016 à 16:21, Adrian Klaver a écrit : The restore fails on a lot of statements, complaining about dependencies. For instance, "cannot drop rule _RETURN on view myview1 because view myview1requires it". Or "cannot drop constraint

Re: [GENERAL] pg_restore --clean failing due to dependancies

2016-11-15 Thread Adrian Klaver
-l "D:\db.dump" to see what pg_restore thinks is the order of restore. Thanks for your help ! Cheers -- Arnaud -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

2016-11-15 Thread Adrian Klaver
t]: Database [postgres]: Port [5433]: 5435 Username [postgres]: psql: FATAL: role "postgres" does not exist As which user (OS user account) you have created the postgresql instance ? which means, you need to login as "Administrator" user.

Re: [GENERAL] Fwd: Mail to be posted in PostgreSQL community

2016-11-15 Thread Adrian Klaver
2 After step 4 it doesn't show up for me in services list – Valentin Kuzub Sep 2 '15 at 13:18 @ValentinKuzub: I had to use "NT Authority\NetworkService" as user name (with empty password) in step 4, then the new instance did show up in the list of services

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-14 Thread Adrian Klaver
6 at 16:31, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 11/09/2016 11:35 PM, Cynthia Hombakazi Ngejane wrote: Hello, I have two databases SQLlite and Postgres, SQLite is my local database in it I

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-14 Thread Adrian Klaver
mented out or not. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_dumpall: could not connect to database "template1": FATAL:

2016-11-13 Thread Adrian Klaver
your cake and eat it to by using pg_dump for individual databases and then pg_dumpall -g where -g is: "-g --globals-only Dump only global objects (roles and tablespaces), no databases. " Best Regards, Robert On 13 Nov 2016, at 19:13, Adrian Klaver <adrian.kla...@aklave

Re: [GENERAL] pg_dumpall: could not connect to database "template1": FATAL:

2016-11-13 Thread Adrian Klaver
egards, Robert On 13 Nov 2016, at 00:37, Scott Marlowe <scott.marl...@gmail.com <mailto:scott.marl...@gmail.com>> wrote: On Sat, Nov 12, 2016 at 2:31 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 11/12/2016 01:20 PM, aw

Re: [GENERAL] pg_dumpall: could not connect to database "template1": FATAL:

2016-11-12 Thread Adrian Klaver
ine that uses trust as the auth method for user postgres connect that way. https://www.postgresql.org/docs/9.5/static/auth-methods.html#AUTH-TRUST Thank you. Best Regards, Robert -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] row => text => row

2016-11-11 Thread Adrian Klaver
Mamin -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgresql 94 from PostgreSQL RPM Repository (with Yum)

2016-11-10 Thread Adrian Klaver
; ac_fn_c_check_header_mongrel "$LINENO" "libpq-fe.h" "ac_cv_header_libpq_fe_h" "$ac_includes_default" if test "x$ac_cv_header_libpq_fe_h" = xyes; then : So it is looking in the default source install locations. The RPMs I believe

Re: [GENERAL] Syncing Data of data type BLOB into Postgres- Bytea

2016-11-10 Thread Adrian Klaver
into Postgres? Please Help... CH Ngejane -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Role and grants

2016-11-09 Thread Adrian Klaver
| {} Regards. -------- *De:* Adrian Klaver <adrian.kla...@aklaver.com> *Enviado:* miércoles, 9 de noviembre de 2016 21:02 *Para:* Fran ...; pgsql-general@postgresql.org *Asunto:* Re: [GENERAL] Role and grants On 11/09/2016 11:05 AM, Fran ... wrote: Hi, I am a new user with Po

Re: [GENERAL] Role and grants

2016-11-09 Thread Adrian Klaver
re: https://www.postgresql.org/docs/9.5/static/sql-grant.html Look for: "The entries shown by \dp are interpreted thus:" Finally, I don't find some command like "show grants for..." in MySQL. Regards. Bryan -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgs

Re: [GENERAL] which work memory parameter is used for what?

2016-11-09 Thread Adrian Klaver
> -- > *Andreas Joseph Krogh* > CTO / Partner - Visena AS > Mobile: +47 909 56 963 > andr...@visena.com <mailto:andr...@visena.com> > www.visena.com <https://www.visena.com> > <https://www.visena.com> > -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Best practices to manage custom statistics

2016-11-08 Thread Adrian Klaver
ll the database when they need the information. If more details are needed, just ask. Thanks in advance and sorry for the long message (but I had to explain such a complex thing) Moreno.- -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] resolution order for foreign key actions?

2016-11-08 Thread Adrian Klaver
be fired in alphabetical order by name." There is more, so I would read through the whole thing. Thanks, Karl -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www

Re: [GENERAL] Fwd: Creating multiple instances of postresql on Windows environment

2016-11-08 Thread Adrian Klaver
the change. 3) It is running and is using port 5434, but a firewall rule is blocking access. Solution: Check whether you have a firewall running and whether it is blocking port 5434. __ __ Please help me to resolve the issue. __ __ -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] Changing foreign key referential actions in big databases

2016-11-07 Thread Adrian Klaver
e the foreign key referential actions quickly and/or without an exclusive lock? Are there indexes on the child columns? Is it safe(ish) to just update pg_constraint.confupdtype and pg_constraint.confdeltype for those? Regards -- Arthur Silva -- Adrian Klaver adrian.kla...@aklaver

Re: [GENERAL] Dynamic execution returning large result sets

2016-11-06 Thread Adrian Klaver
ext: http://postgresql.nabble.com/Dynamic-execution-returning-large-result-sets-tp5929177.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Adrian Klaver
On 11/06/2016 09:24 AM, Benjamin Adams wrote: Please Reply to list also. I have Cced list > On Nov 6, 2016 11:07 AM, "Adrian Klaver" <adrian.kla...@aklaver.com > <mailto:adrian.kla...@aklaver.com>> wrote: >> >> On 11/06/2016 06:11 AM, Benjamin Adams wrote

Re: [GENERAL] timestamp without timezone to have timezone

2016-11-06 Thread Adrian Klaver
gres has no internal way of knowing what the timestamp(w/o tz) data values are anchored to. This leads to another question. Did all the current values originate from EST? > Or will it just not make the adjustment? See above. > > Thanks > Ben -- Adrian Klaver adrian.kla...@akla

Re: RES: [GENERAL] Trouble with regexp_matches

2016-11-05 Thread Adrian Klaver
On 11/05/2016 11:56 AM, Edson Richter wrote: -Mensagem original- De: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Enviada em: sábado, 5 de novembro de 2016 15:13 Para: Edson Richter <edsonrich...@hotmail.com>; pgsql- gene...@postgresql.org Assunto: Re: [GENERAL] T

Re: [GENERAL] Trouble with regexp_matches

2016-11-05 Thread Adrian Klaver
-- select codigoocorrencia, datahoraocorrencia, datahoraimportacao, observacao from batchloteocorrencia where codigoocorrencia = '091' and observacao is not null order by datahoraimportacao DESC Total results = 3826 Why is that? Regards, Edson Richter -- Adrian Klaver adrian.kla...@a

Re: [GENERAL] Recover from corrupted database due to failing disk

2016-11-04 Thread Adrian Klaver
On 11/04/2016 03:20 AM, Gionatan Danti wrote: On 03/11/2016 14:20, Adrian Klaver wrote: The above does not make sense. You are having to recover because there was no backup and now you want to go forward without doing a backup? Hi Adrian, no, I don't want go forward without backups

Re: [GENERAL] Recover from corrupted database due to failing disk

2016-11-03 Thread Adrian Klaver
there was no backup and now you want to go forward without doing a backup? Thank you very much Jim. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] initdb createuser commands

2016-10-31 Thread Adrian Klaver
pg >> PG(1)User Commands >> PG(1) >> >> NAME >>pg - browse pagewise through text files >> >> SYNOPSIS >>pg [-number] [-p string] [-cefnrs] [+line] [+/pattern/] [file...] >> ... >> >> Also, the same

Re: [GENERAL] Rows are repeating by the trigger function

2016-10-31 Thread Adrian Klaver
: On 31 October 2016 at 14:41, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: > On 10/31/2016 02:06 AM, Kiran wrote: >> I know 94 = 1 + (3 * 31). >> I am just having a normal insert statement into cf_question table.

Re: [GENERAL] Way to quickly detect if database tables/columns/etc. were modified?

2016-10-31 Thread Adrian Klaver
w.postgresql.org/message-id/CANu8FizWg8GMSmm_d8X0B6uYi7o535f3vqMD3nqFXqrrYB6huA%40mail.gmail.com https://www.postgresql.org/message-id/mbrynjrrq6ckoxap20n2gqx4.1461185428476%40email.android.com > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > w

Re: [GENERAL] How to optimize SELECT query with multiple CASE statements?

2016-10-31 Thread Adrian Klaver
s Thank you Alex -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Rows are repeating by the trigger function

2016-10-31 Thread Adrian Klaver
statement? I know 94 = 1 + (3 * 31). I am just having a normal insert statement into cf_question table. Are there any other triggers on the tables? regards Kiran On Sun, Oct 30, 2016 at 3:01 PM, Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com&g

Re: [GENERAL] initdb createuser commands

2016-10-30 Thread Adrian Klaver
Kind regards, Samuel -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] initdb createuser commands

2016-10-30 Thread Adrian Klaver
cription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] initdb createuser commands

2016-10-30 Thread Adrian Klaver
, "pg createuser". psql -c "create user " -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver

Re: [GENERAL] Rows are repeating by the trigger function

2016-10-30 Thread Adrian Klaver
it but with the same 94 rows in the table. It would be great if any from the forum point to me where I am doing wrong. regards Kiran -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] initdb createuser commands

2016-10-29 Thread Adrian Klaver
that into 'Access the database shell' where the database you connect to is postgres instead of myDatabaseName and you create the user and database using SQL commands. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Cannot access the return value of a PostgreSQL function using ADO

2016-10-29 Thread Adrian Klaver
o get the Postgres Function Return Value? Maybe this?: https://www.postgresql.org/message-id/20040531142048.1067.qmail%40web20806.mail.yahoo.com > > > > I am developing on a Windows 7 Professional (SP1) operating system. > Using Microsoft Visual Basic 6.0(SP6), Microsoft A

Re: [GENERAL] E-R diagram code U1

2016-10-29 Thread Adrian Klaver
to this agency. http://stackoverflow.com/questions/5628533/what-does-i1-i2-u1-means-in-visio-database-relationship-diagram http://stackoverflow.com/questions/23533702/about-entity-relationship-diagram Thanks, Rich -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general

Re: [GENERAL] initdb createuser commands

2016-10-29 Thread Adrian Klaver
anges to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] initdb createuser commands

2016-10-28 Thread Adrian Klaver
or like 20 years, its kinda late to change them -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@aklaver.c

Re: [GENERAL] initdb createuser commands

2016-10-28 Thread Adrian Klaver
K) that do not have pg or postgres in the name are just wrappers around the SQL commands of the same name(roughly) eg dropdb = DROP DATABASE. initdb is now accessible from pg_ctl: https://www.postgresql.org/docs/9.5/static/app-pg-ctl.html Thanks Samuel -- Adrian Klaver adrian.kla...@a

Re: [GENERAL] deadlock error - version 8.4 on CentOS 6

2016-10-28 Thread Adrian Klaver
autovacuum be causing this, since no one else is updating this database table. Is there more then one instance of the application running? Thanks, -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Escape variable

2016-10-27 Thread Adrian Klaver
$$ DECLARE esc_str varchar; BEGIN esc_str = E'Se recibi\u00f3 a \n ci\u00f3n.' ; RAISE NOTICE '%', esc_str; END; $$ LANGUAGE plpgsql; NOTICE: Se recibió a ción. DO If not then can you show an example from in plpgsql? Thanks Jaime -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1

2016-10-26 Thread Adrian Klaver
l post: " ... 2. After the standby is removed from the primary, both of nodes are in standalone configuration. " -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

2016-10-24 Thread Adrian Klaver
They do if there is no reason to do a custom compile. As it turns out there was a reason, so we return to regularly scheduled programing:) -- john r pierce, recycling bits in santa cruz -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.or

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

2016-10-24 Thread Adrian Klaver
and install a modified version of the PostgreSQL extension pl/r. Andre Mikulec andre_miku...@hotmail.com -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

2016-10-24 Thread Adrian Klaver
://www.enterprisedb.com/products-services-training/pgdownload#windows provide with their Windows binaries? Andre Mikulec andre_miku...@hotmail.com -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] configure PostgreSQL with PERL: Perl version 5.8 or later is required, but this is .

2016-10-23 Thread Adrian Klaver
On 10/23/2016 04:05 PM, Andre Mikulec wrote: I corrected 'PERL=' to include the executable. I tried again. Where did you get the Postgres source you are trying to build? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Doubts about replication from many servers

2016-10-21 Thread Adrian Klaver
is needed: 1) Are all 4 PG servers the same version, on the same OS, same chip architecture? 2) What replication method do you want to use? And if some PG server goes down, how to recovery the system from PG backup after I reconfigure the PG original server? -- Adrian Klaver adrian.kla

Re: [GENERAL] configure PostgreSQL with the python: distutils module not found

2016-10-20 Thread Adrian Klaver
ger, and Python contains pip and easy_install package managers. There is no package manager for TCL/TK. ... " regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] configure PostgreSQL with the python: distutils module not found

2016-10-20 Thread Adrian Klaver
ils Please help. Thank you. Andre Mikulec andre_miku...@hotmail.com -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Selecting records with highest timestamp - for a join

2016-10-19 Thread Adrian Klaver
(6 rows) test[5432]=# select * from ts_stamp_test where uid = 1 order by stamp desc limit 1; id | uid | stamp +-+--- 5 | 1 |18 (1 row) > > Regards > Alex >

Re: [GENERAL] Selecting records with highest timestamp - for a join

2016-10-19 Thread Adrian Klaver
returning a table from words_get_games() you can experiment by joining it's output to words_social. Thank you for any hints Alex -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgre

Re: [GENERAL] pg_sample

2016-10-18 Thread Adrian Klaver
orporation http://www.endpoint.com/ PGP Key: 0x14964AC8 201610182256 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEAREDAAYFAlgG4NkACgkQvJuQZxSWSsge4ACePhBOBtBFnGNxXt5qpY7X+w3o d04AoKTzAgxcaqy8qfIE0LPuzG9x0KIU =sS+m -END PGP SIGNATURE----- -

Re: [GENERAL] pg_sample

2016-10-18 Thread Adrian Klaver
r much (never tried pg_sample to be honest). -- Michael Actually it does matter because there is some essential data that has to be in there so the code can work. Well random does not know essential, it is after all random. If you want to test specific cases then you will need to build appropriate

Re: [GENERAL] Dump all the indexes/constraints/roles

2016-10-17 Thread Adrian Klaver
On 10/17/2016 08:32 PM, Patrick B wrote: Hi guys, I need to export an entire database to another server, for testing purpose. Is there any way to export all indexes and constraints ? pg_dump the_database Postgres 9.2 Patrick -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql

Re: [GENERAL] Problem changing default data_directory in PG 9.6 + CentOS6

2016-10-17 Thread Adrian Klaver
in3. Then, start/stop/start/etc run fine lookup for postmaster.pid in /var/lib/pgsql/9.6/data. So you either need to change the start script to point to the new cluster or create a new one for it. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] could not connect to server

2016-10-16 Thread Adrian Klaver
tabase available now. Thanks. Best regards, Antônio Olinto -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] could not connect to server

2016-10-16 Thread Adrian Klaver
Well, but I have my database available now. Thanks. Best regards, Antônio Olinto 2016-10-15 14:28 GMT-03:00 Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>: On 10/15/2016 10:11 AM, Antonio Silva wrote: Hello I'm using postgres 9.

Re: [GENERAL] could not connect to server

2016-10-15 Thread Adrian Klaver
try to connect? I really appreciate any guidance. All the best, Antônio Olinto São Paulo, Brasil -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Issue with installation of postgresql server

2016-10-13 Thread Adrian Klaver
you should delete this message and any disclosure, copying, or distribution of this message, or the taking of any action based on it, by you is strictly prohibited. v.E.1 -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-13 Thread Adrian Klaver
On 10/12/2016 08:57 AM, arnaud gaboury wrote: On Wed, Oct 12, 2016 at 3:41 PM Adrian Klaver <adrian.kla...@aklaver.com So other then adding the mapping for the dovecot user, did anything else change? after a little bit of cleaning and a change in my Postgres username (

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread Adrian Klaver
working here: https://www.postgresql.org/message-id/CAK1hC9uLhsyn4g8Fc1FwhnDQzNx9k115GkK9iFKHepfjeMc%2Beg%40mail.gmail.com So other then adding the mapping for the dovecot user, did anything else change? regards, tom lane -- Adrian Klaver adrian.kla...@ak

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-12 Thread Adrian Klaver
part: . Do you mean best would be for dovecot to log in as dovecot Postgres user, and mattermost as mattermost Postgres user ? Thank you for precising. Yes, that was Tom was getting at. Create dovecot and mattermost roles(users) in Postgres. . regards, tom lane

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-11 Thread Adrian Klaver
before, because you had this: psql postgresql://mmuser:XXX@/mattermost? > > Thank you for help. > > > -- Adrian Klaver adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> -- Adrian Klaver adrian.kla...@akla

Re: [GENERAL] confusion about user paring with pg_hba and pg_ident

2016-10-11 Thread Adrian Klaver
es that linux user mattermost was mapped by psql user mmuser (which of course holds the mattermost DB), but it seems it is not the case. What do I do wrong? Did you remember to reload Postgres? Thank you for help. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing lis

Re: [SPAM] [GENERAL] psql 9.3 automatic recovery in progress

2016-10-10 Thread Adrian Klaver
ns 2016-10-10 09:00:08 PDT LOG: autovacuum launcher started Thanks. On Mon, Oct 10, 2016 at 11:32 AM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: On 10/10/2016 11:14 AM, Moreno Andreo wrote: Il 10/10/2016 18:24, Periko Support ha scritto: 2016-09-12 09:00:01 PDT LOG: server pr

Re: [SPAM] [GENERAL] psql 9.3 automatic recovery in progress

2016-10-10 Thread Adrian Klaver
ith postgres?" While we on the subject, the datetimes are almost a month old. Does that mean this problem was just noticed or are the datetimes wrong? Cheers, Moreno. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
On 10/09/2016 09:40 AM, Tom Lane wrote: Adrian Klaver <adrian.kla...@aklaver.com> writes: On 10/09/2016 08:46 AM, Tom Lane wrote: Clearly a bug --- the wrong type OIDs are being passed down to array_append. It should be told that it's getting called as For my edification, wh

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
refactoring code in the aggregate/windowfunction area. Possibly me :-(. Haven't found exactly where things are going off the rails, but it's clearly a PG bug. Thanks for the report! regards, tom lane -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-gene

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
On 10/09/2016 08:01 AM, Sebastian P. Luque wrote: On Sun, 9 Oct 2016 06:44:10 -0700, Adrian Klaver <adrian.kla...@aklaver.com> wrote: [...] Not sure. When I tried using the above(on 9.5) it failed during the CREATE OR REPLACE FUNCTION public.angle_vectors_avg stage with: ERROR

Re: [GENERAL] custom average window function failure

2016-10-09 Thread Adrian Klaver
iled during the CREATE OR REPLACE FUNCTION public.angle_vectors_avg stage with: ERROR: type "vector" does not exist So where is that coming from in your setup? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Libpq functions & string to obtain connection parameters

2016-10-07 Thread Adrian Klaver
b err:pq: SSL is not enabled on the server That does not look like something coming from Postgres, but from whatever is initiating the connection. Is it normal to still have this error ? Adding sslmode param will not change anything as it is ignored for Unix domain socket communication. --

Re: [GENERAL] Libpq functions & string to obtain connection parameters

2016-10-07 Thread Adrian Klaver
On 10/07/2016 07:28 AM, arnaud gaboury wrote: On Fri, Oct 7, 2016 at 3:56 PM Adrian Klaver <adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote: On 10/07/2016 06:42 AM, arnaud gaboury wrote: > > > > Honestly not so much, as it is a

Re: [GENERAL] Libpq functions & string to obtain connection parameters

2016-10-07 Thread Adrian Klaver
?connect_timeout=10 4409 ?Ss 0:00 postgres: aklaver test [local] idle -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Libpq functions & string to obtain connection parameters

2016-10-07 Thread Adrian Klaver
ices -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] postgresql-8.1.18-2.1 information

2016-10-06 Thread Adrian Klaver
past End-of-Life: https://www.postgresql.org/support/versioning/ Close as I can come is the source version: https://www.postgresql.org/ftp/source/v8.1.18/ Regards, Yogesh -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] pgadmin III for PostgreSQL 9.6

2016-10-06 Thread Adrian Klaver
to use the issue tracker. n.b. the latest version of pgadmin III seems to work after a couple of error messages during the start. Thanks Klaus -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Transactional-DDL DROP/CREATE TABLE

2016-10-06 Thread Adrian Klaver
So is it possible to show a complete example of what you are doing? And the notice is not the reason it is not done at commit time, the reason is the one you said, action must be taken when you issue the command, not a magic convenient time in the future I've no idea what this paragraph means. G

Re: [GENERAL] Transactional-DDL DROP/CREATE TABLE

2016-10-06 Thread Adrian Klaver
); ERROR: duplicate key value violates unique constraint "pg_type_typname_nsp_index" DETAIL: Key (typname, typnamespace)=(ddl_test, 2200) already exists. test=# commit ; ROLLBACK So not having the table when you start both sessions seems to be the issue. Geoff -- Adrian Klaver adria

Re: [GENERAL] isnull() function in pgAdmin3

2016-10-03 Thread Adrian Klaver
list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

2016-10-03 Thread Adrian Klaver
On 10/03/2016 02:27 AM, Tim Clarke wrote: On 01/10/16 01:43, Adrian Klaver wrote: Before you run the python setup.py part you will then have to install a lot of Flask dependencies: Flask-Babel==0.11.1 Flask-Gravatar==0.4.2 Flask-Login==0.3.2 Flask-Mail==0.9.1 Flask-Principal==0.4.0 Flask

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Adrian Klaver
our system default? Second there seems to be some unfilled dependencies: python-blinker >= 1.3 libpython2.7_d.so.1.0()(64bit) At a guess you can try to YUM install python-blinker for the first. For the second I am thinking you need something along the lines of python-devel installed.

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

2016-09-30 Thread Adrian Klaver
dependencies: Flask-Babel==0.11.1 Flask-Gravatar==0.4.2 Flask-Login==0.3.2 Flask-Mail==0.9.1 Flask-Principal==0.4.0 Flask-Security==1.7.5 Flask-SQLAlchemy==2.1 Flask-WTF==0.13 also: django-htmlmin==0.9.1 Then run python setup.py. Personally I would go this route: https://www.pgadmin.org/do

Re: [GENERAL] System crashed: fatal error restarting postgres

2016-09-30 Thread Adrian Klaver
09121701270.1140%40localhost > > TIA, > > Rich > > -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-30 Thread Adrian Klaver
On 09/30/2016 08:18 AM, dudedoe01 wrote: Select version(); shows postgreSQL 9.6beta3, compiled by Visual C++ build 1800, 64-bit There is no isnull() in 9.6 either, if that is what you are asking? Otherwise what is the question you want answered? -- Adrian Klaver adrian.kla...@aklaver.com

Re: [GENERAL] [ANNOUNCE] pgAdmin 4 v1.0 Released!

2016-09-30 Thread Adrian Klaver
the pgAdmin4 runtime outside the build environment and run it? Can you import Flask in a Python interpreter? Do you have multiple versions of Python and if so are you sure the apt-get is installing Flask into the same version that pgAdmin4 is using? Sigh -- Adrian Klaver adrian.kla.

Re: [GENERAL] System crashed: fatal error restarting postgres

2016-09-30 Thread Adrian Klaver
not open shared memory segment "/PostgreSQL.1804289383": Permission denied Please advise me on how I proceed to clear this and restart the application. See here: https://www.postgresql.org/message-id/24208.1473724630%40sss.pgh.pa.us TIA, Rich -- Adrian Klaver adrian.kla...@a

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-29 Thread Adrian Klaver
s. You might need to add explicit type casts. -- View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122p5923277.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Se

Re: [GENERAL] pg_upgrade from 9.5 to 9.6 fails with "invalid argument"

2016-09-29 Thread Adrian Klaver
16410/85358_vm" to "d:/Daten/db/pgdata96/base/16411/85358_vm"): Invalid argument Failure, exiting The file in question is 65.536 bytes in size. I saved all log files and the complete output from the failed run, so if you are interested I can supply them (I ran pg_upgrade with the --re

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-28 Thread Adrian Klaver
ss" = m."Address" and g."nhs_can" = 'false' and g."nhs_build_spec" = 'Build' then 'Build' when g."nhs_address" = m."Address" and g."nhs_can" = 'false' and g."nhs_build_spec" = 'Spec' then 'Spec' else '' end)) as "Build/Spec

Re: [GENERAL] Determining server load

2016-09-27 Thread Adrian Klaver
K 99709 (907) 450-7293 --- -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsq

Re: [GENERAL] Determining server load

2016-09-27 Thread Adrian Klaver
bscription: http://www.postgresql.org/mailpref/pgsql-general -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] isnull() function in pgAdmin3

2016-09-27 Thread Adrian Klaver
r@test=> select null isnull; ?column? -- t (1 row) -- View this message in context: http://postgresql.nabble.com/isnull-function-in-pgAdmin3-tp5923122.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent

Re: [GENERAL] Determining server load

2016-09-27 Thread Adrian Klaver
99709 (907) 450-7293 ------- -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] need approval to join forums/community

2016-09-26 Thread Adrian Klaver
ailing Lists https://www.postgresql.org/list/ or Community account: https://www.postgresql.org/account/signup/ or both or something else? Also, how did you sign up? thanks PhaniKumar -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] Chante domain type - Postgres 9.2

2016-09-26 Thread Adrian Klaver
On 09/26/2016 07:38 AM, Rob Sargent wrote: On 09/26/2016 08:14 AM, Adrian Klaver wrote: On 09/26/2016 06:54 AM, Thomas Kellerer wrote: Rakesh Kumar schrieb am 26.09.2016 um 15:08: You sound like you think that varchar(50) is somehow cheaper than text. The biggest impediment to text cols

Re: [GENERAL] Chante domain type - Postgres 9.2

2016-09-26 Thread Adrian Klaver
On 09/26/2016 07:38 AM, Rob Sargent wrote: On 09/26/2016 08:14 AM, Adrian Klaver wrote: On 09/26/2016 06:54 AM, Thomas Kellerer wrote: Rakesh Kumar schrieb am 26.09.2016 um 15:08: You sound like you think that varchar(50) is somehow cheaper than text. The biggest impediment to text cols

Re: [GENERAL] Chante domain type - Postgres 9.2

2016-09-26 Thread Adrian Klaver
without length specifier, the type accepts strings of any size. The latter is a PostgreSQL extension." This allows you to have 'text' without it being called text, as stated below. There is no difference whatsoever between varchar and text in Postgres. -- Adrian Klaver adrian.kla...@a

Re: [GENERAL] Question on replace function [solved]

2016-09-25 Thread Adrian Klaver
regards, tom lane > > -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

<    3   4   5   6   7   8   9   10   11   12   >