Hi,
I deployed pgAdmin4 on a server and I have a script that every day restore
a database from a dump file. The problem I am facing at, is that if
somebody forget to diconnect from the database, the restore command fails
with an error "database Test is being accessed by other users".
Is there a w
On Mon, Dec 19, 2016 at 7:28 AM, Paolo Saudin wrote:
> Hi,
>
> I deployed pgAdmin4 on a server and I have a script that every day restore
> a database from a dump file. The problem I am facing at, is that if
> somebody forget to diconnect from the database, the restore command fails
> with an err
Hi !
Does anyone know how to log or debug authentication against ad?
A few years ago is it was possible to log everything to confirm using the
right KDC and the right principal and hereby be sure to send the right
userid possible concatenated with the realm.(I can't remember exacty) As
far as I ca
You can leave authentication to something else. For example authenticate
the users by having them connect to pgBouncer first.
-Joseph
On Fri, Dec 16, 2016 at 11:17 AM, Andomar wrote:
> We run a master server and a hot standby server. Reporting users login to
> the standby server to run long que
gdb is not available on this machine. Neither which or locate could find it.
The servers we're given are truly, shockingly, stripped down models.
At this point, I believe my best course of action is to twist some sys admin
arms and get a properly installed PostgreSQL on this machine. Even if
The slave:
$ pg_controldata --version
pg_controldata (PostgreSQL) 9.4.1
$ echo $PGDATA
/apps/database/postgresql-data
$ pg_controldata $PGDATA
WARNING: Calculated CRC checksum does not match value stored in file.
Either the file is corrupt, or it has a different layout than this program
is expecti
Dear Sir/Mam,
I am also trying to send emails with attachments.please help me out with
this.
Regards,
Nidhi
On Thu, 15 Dec 2016 16:42:13 + (GMT)
Richard Brosnahan wrote:
>
> I get a checksum error, from pg_ctl.
> 2016-12-15 08:27:14.520 PST >FATAL: incorrect checksum in control file
>
Hi Richard,
Not sure if it applies, but just in case, I got this error when trying to use a
cluster copied fr
>Von: Adrian Klaver
>An:thomas.deboben@rohde-schwarz.com, pgsql-general@postgresql.org
>Datum: 09.12.2016 22:21
>Betreff: Re: [GENERAL] Windows installation - could not connect to
server: Connection refused (0x274D/10061)
>
>On 12/09/2016 12:43 AM, thomas.deboben@rohde-sch
Hello List, I am setting up Postgres 9.6 for streaming replication. The OS is Solaris X86 I downloaded the postgres solaris binaries from the Postres site and installed on 2 instances of Solaris 10. I then used pg_dumpall to load the master server with data from our devel0pment server. That
Hello,
I've encountered a disturbing behaviour using the || operator on two jsonb
objects extracted from subfields of a common jsonb object.
Let's take a look at this example :
with data as (
select '{
"nested1": {"lvl1_k1": "v1"},
"nested2": {"lvl2_k1":234, "lvl2_k
Hi,
I am using PostgreSQL 9.4.8 on x86_64-unknown-linux-gnu, compiled by gcc
(Debian 4.9.2-10) 4.9.2, 64-bit.
I have a notification table with about ~45 000 000 rows.
I have some performance issues when trying to fetch rows from the table
with a specific query, I suspect the planner to choose th
Hi
2016-12-16 7:07 GMT+01:00 nidhi raina :
> Dear Sir/Mam,
>
> I am also trying to send emails with attachments.please help me out with
> this.
>
You can use a untrusted Perl or Python functions
http://www.perlmonks.org/?node_id=603769
here is one example
http://postgres.cz/wiki/PL/Perlu_-_Untr
=?UTF-8?Q?Micka=C3=ABl_Le_Baillif?= writes:
> Let's take a look at this example :
> with data as (
> select '{
> "nested1": {"lvl1_k1": "v1"},
> "nested2": {"lvl2_k1":234, "lvl2_k2": "test"}
> }'::jsonb as extra_values,
> '{"aaa": 12}'::jsonb as j1,
On 12/15/2016 10:07 PM, nidhi raina wrote:
Dear Sir/Mam,
I am also trying to send emails with attachments.please help me out with
If as your subject suggests you are using this:
https://github.com/captbrando/pgMail
then it is not possible to send attachments:
"Essentially, pgMail is simply
On Mon, Dec 19, 2016 at 12:05 PM, Christophe Escobar <
christophe.e...@gmail.com> wrote:
> Hi,
>
> I am using PostgreSQL 9.4.8 on x86_64-unknown-linux-gnu, compiled by gcc
> (Debian 4.9.2-10) 4.9.2, 64-bit.
>
> I have a notification table with about ~45 000 000 rows.
>
> I have some performance is
On 12/16/2016 07:01 AM, thomas.deboben@rohde-schwarz.com wrote:
Von:Adrian Klaver
An:thomas.deboben@rohde-schwarz.com,
pgsql-general@postgresql.org
Datum:09.12.2016 22:21
Betreff:Re: [GENERAL] Windows installation - could not connect
to server: Connecti
Christophe Escobar writes:
> I have some performance issues when trying to fetch rows from the table
> with a specific query, I suspect the planner to choose the wrong index
> because of the limit.
> ...
> 1) Why is the planner changing index scanning at the threshold of 45 for
> the LIMIT ?
That
On 12/15/2016 2:16 PM, Richard Brosnahan wrote:
gdb is not available on this machine. Neither which or locate could
find it. The servers we're given are truly, shockingly, stripped down
models.
what OS is this, what compiler toolchain did you use to build postgres
on them?
--
john r pie
> On 19 Dec 2016, at 18:55, Adrian Klaver wrote:
>
> On 12/15/2016 10:07 PM, nidhi raina wrote:
>> Dear Sir/Mam,
>>
>> I am also trying to send emails with attachments.please help me out with
>
> If as your subject suggests you are using this:
>
> https://github.com/captbrando/pgMail
>
> the
On Mon, Dec 19, 2016 at 4:40 AM, wrote:
> Hello List,
> I am setting up Postgres 9.6 for streaming replication. The OS is
> Solaris X86 I downloaded the postgres solaris binaries from the Postres
> site and installed on 2 instances of Solaris 10. I then used pg_dumpall to
> load the master
21 matches
Mail list logo
