and deny all other?
Best Regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
apply 16627:1763399739 (PID 16767) beendete mit Status 1
I have retry< setup multipole times, always the same error.
What i have done wrong?
Best Regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.
i have fixed. pg_update has create a wrong cluster
On 14.08.2017 20:52, basti wrote:
Hello,
i try to replicate my database. what i have done?
- create a cluster on slave (UTF8, en_US.utf8 collate/c_type)
- stop cluster and cleanup datadir
- do basebackup from master
- start db-cluster
/Streaming_Replication
and had install an other cluster in the past with successful.
How can help please?
Best regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
i have a webapp convert from ascii to uft8.
Now I get in postgres
ERROR: invalid byte sequence for encoding "UTF8": 0xfc
Now I try to log all queries with log_statement = 'all'.
All queries are longed expected this one.
Is there a way to debug this.
Best Regards,
Basti
--
^
ERROR: syntax error at or near "a"
LINE 1: a:1:{^CCancel request sent
ERROR: syntax error at or near "s"
LINE 1: s:4:"4508";
^
Is there a way to do a clean backup and restore with this json data?
best regards,
basti
--
Sent via pgsq
I want to create a generic own_postgres.conf and include that in
postgres.conf
I ask a bit wrong. Is there a variable to include postgres version on
log_filename?
Best regards
basti
Am 18.07.2017 um 10:40 schrieb Achilleas Mantzios:
> On 18/07/2017 11:36, Walter Nordmann wrote:
>> M
I want to create a generic own_postgres.conf and include that in
postgres.conf
I ask a bit wrong. Is there a variable to include postgres version on
log_filename?
Best regards
basti
Am 18.07.2017 um 10:40 schrieb Achilleas Mantzios:
> On 18/07/2017 11:36, Walter Nordmann wrote:
>> M
Hello,
in my postgres.conf i use
log_filename = 'postgresql-%Y-%m-%d.log'
this results in Logfiles named "postgresql-2017-07-14.log"
Is there a way to create logfiles
"postgresql--2017-07-14.log"
Best Regards,
Basti
--
Sent via pgsql-general mailing list (pgsql-ge
that?
Is it possible to use on Master Version 9.1 and on Slave 9.6 (it will
get the new master in the next step)?
Best Regards,
Basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
is there a recomment to set max_worker_processes and
max_parallel_workers_per_gather per cpu core or thread?
Best regards
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hallo, we have a Postgres database Server and around that there are 8
clients get data from it.
All servers are the the same datacenter i think (traceroute only 4-5 hops)
Now we plan to move the server to an other hoster/datacenter.
I have done simple test with ping and traceroute.
Is there a
work and then correlate network
> activity with PIDs and then somehow via (pg_stat_* or ps) with queries.
>
>>
>> Em 9h41 Seg, 05/12/2016, basti
>> <<mailto:mailingl...@unix-solution.de>mailingl...@unix-solution.de>
>> escreveu:
>>
>> Hallo,
>&
work and then correlate network
> activity with PIDs and then somehow via (pg_stat_* or ps) with queries.
>
>>
>> Em 9h41 Seg, 05/12/2016, basti
>> <<mailto:mailingl...@unix-solution.de>mailingl...@unix-solution.de>
>> escreveu:
>>
>> Hallo,
>&
9h41 Seg, 05/12/2016, basti <mailingl...@unix-solution.de
> <mailto:mailingl...@unix-solution.de>> escreveu:
>
> Hallo,
>
> I have to try traffic accounting for postgres using tcpdump and nfdump.
> I can see what traffic is produced but cant see
and
its very old (year 2004).
Is there a way to see traffic network of postgres sort by query?
best regards
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
i have a problem with my postgres server. There is a DB with approx 30
GB. the traffic per day is between 20-50 GB on the outgoing interface.
one client has ~ 20 IDLE connections. i have sniffer this connections
with nfdump and get this traffic
2016-11-29 12:05:56.165 5854.304 TCP
Hello,
I try to use PHP with Postgresq1 socket connection. All works fine with
following entry in
pg_hba.conf
local database user trust
or
local database user peer map=someuser
pg_ident.conf
# MAPNAME SYSTEM-USERNAME PG-USERNAME
someuserwww-data
Hello I have a postgres cluster with following databases
davical| pgadmin | UTF8 | en_US.utf8 |
en_US.utf8 |
test| test | LATIN9| en_US.iso885915 |
en_US.iso885915 |
foo| postgres | SQL_ASCII |
a lot.
p.s. os: debian 7 with postgres 9.1
On 05.03.2015 14:36, Adrian Klaver wrote:
On 03/05/2015 02:48 AM, basti wrote:
Hello I have a postgres cluster with following databases
davical| pgadmin | UTF8 | en_US.utf8 |
en_US.utf8 |
test
Please use this http://www.postgresql.org/community/lists/subscribe/ link.
On 28.01.2015 12:01, Quirin Hamp wrote:
Please unsubscribe me from mailing list. Thank you!
Bien cordialement, / Mit freundlichen Grüßen / Yours sincerely,
Quirin HAMP
_
Viessmann
Hello,
months ago I have a similar problem with the OOM-Killer.
Have a look at
http://www.credativ.co.uk/credativ-blog/2010/03/postgresql-and-linux-memory-management
I hope that's helpful.
Regards,
basti
On Sat 25.10.2014 22:55 +0200, Joe Van Dyk j...@tanga.com wrote:
One of my postgres
Hello,
months ago I have a similar problem with the OOM-Killer.
Have a look at
http://www.credativ.co.uk/credativ-blog/2010/03/postgresql-and-linux-memory-management
I hope that's helpful.
Regards,
basti
On Sat 25.10.2014 22:55 +0200, Joe Van Dyk j...@tanga.com wrote:
One of my postgres
or Synchronous?
Am 27.10.2014 17:00, schrieb Joe Van Dyk:
On Mon, Oct 27, 2014 at 8:16 AM, basti mailingl...@unix-solution.de
mailto:mailingl...@unix-solution.de wrote:
Hello,
months ago I have a similar problem with the OOM-Killer.
Have a look at
http://www.credativ.co.uk
Yes all clusters, run on the same machine.
All packages are from pgdg.
libpq5 is version 9.3.4-1.pgdg70+1
the problem is still the same,
The relevant database is only for testing and development,
I will downgrade to 9.1.
Thanks for helping.
Regards,
basti
Am 15.07.2014 16:46, schrieb Adrian
PostgreSQL C client library
Am 15.07.2014 16:33, schrieb Adrian Klaver:
On 07/15/2014 07:17 AM, basti wrote:
Hello Adrian,
Yes I use the correct cluster.
password authentication failed for user testuser ...
is a line from the postgres log
Yes I know what trust mean.
psql in version 9.3
(154.pgdg70+1),
postgresql-contrib-9.3(9.3.4-1.pgdg70+1)
php: php5(5.4.4-14+deb7u12), libphp-adodb(5.15-1),
php5-pgsql(5.4.4-14+deb7u12)
When I try Postgres 9.1 and php 5.4.4 with md5 auth-method, it also
works very well.
Perhaps someone can do a bug report?
Thanks for any help!
Best regards,
basti
the setup.
And I don't use ADO for this test.
I have also test
Postgres 9.1 and Postgres 9.4 both work with auth-method md5, except
postgres 9.3 discuss there.
It takes a round 5 hours to find this error.
If anybody has the same problem be warned.
Regards,
basti
Am 15.07.2014 16:00, schrieb Adrian
PostgreSQL C client library
Am 15.07.2014 16:33, schrieb Adrian Klaver:
On 07/15/2014 07:17 AM, basti wrote:
Hello Adrian,
Yes I use the correct cluster.
password authentication failed for user testuser ...
is a line from the postgres log
Yes I know what trust mean.
psql in version 9.3
Hello,
I had followed this discuss
(http://www.postgresql.org/message-id/CABRT9RAXzUa=_zT_M4Z1vyDuFkpgNCZLUnRTUO5gvK2kKkNu=a...@mail.gmail.com).
I have a similar problem now:
I use one Postgres Server as Master an an other one as Standby (WAL
archives).
I do also a daily backup of the Master
to connect via
psql -U user -h localhost -W database
I can connect without error.
I also use SSL connections, is this the problem? or in other words is
there a way to connect php via (postgres) ssl?
Regards,
basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Yes, there is the same problem.
postgres logs also:
Connection matched pg_hba.conf line 93
„hostall all 127.0.0.1/32md5“
Am 09.07.2014 13:14, schrieb Bill Moran:
On Wed, 09 Jul 2014 13:04:19 +0200 basti mailingl...@unix-solution.de wrote:
Hello my
Here is the output of the echo.
host=127.0.0.1 user=mydns password=mypass sslmode=allow dbname=mydns
I have also try host=localhost and sslmode=require
Am 09.07.2014 13:47, schrieb Francisco Olarte:
Hi:
On Wed, Jul 9, 2014 at 1:04 PM, basti mailingl...@unix-solution.de wrote:
Hello my
md5
did not work.
I use Postgres 9.3.4-1.pgdg70+1. (debian)
Am 09.07.2014 15:06, schrieb Adrian Klaver:
On 07/09/2014 04:04 AM, basti wrote:
Hello my pg_hab.conf has this entry:
hostall all 127.0.0.1/32md5
Is that the only entry
Is there a simple md5 hash?
I also try to hash my passwd via md5.
There is sill the same error.
Am 09.07.2014 15:19, schrieb rob stone:
Are you encrypting the password? If not, alter the pg_hba.conf file to
trust instead of md5. If it's all running on localhost it's no big
deal.
--
Sent via
I don't know whats wrong there
hostmydns mydnslocalhost trust
works well and
#hostall all 0.0.0.0 0.0.0.0 md5
did not work.
I use Postgres 9.3.4-1.pgdg70+1.
Am 09.07.2014 14:04, schrieb basti:
Here is the output
fix this?
Thanks,
Basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
is it possible to have WAL Replication and Point-in-Time Recovery like
follows:
DB-Master -- (WAL to Slave) -- DB-Slave
|
|--- (PITR to an other Server)
Thanks for any help!
Basti
p.s. is there a tutorial somewhere how describe the steps todo when the
master is crashed
Hello,
is it possible to have WAL Replication and Point-in-Time Recovery like
follows:
DB-Master -- (WAL to Slave) -- DB-Slave
|
|--- (PITR to an other Server)
Thanks for any help!
Basti
p.s. is there a tutorial somewhere how describe the steps todo when the
master is crashed
-rtl
-rw--- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat
There is no /run/shm/pgstat.tmp file but if I create it and change the
owner to postgres the file will be removed few minutes later.
How can explain and how can I solve this error?
Regards,
Basti
--
Sent via pgsql-general
/run/shm and /var/run/shm would be the same. On my system I found no
symlink to each other but there is the same content.
Basti
On 22.04.2014 12:02, Tomáš Vondra wrote:
Seems you're using /run/shm and /var/run/shm by mistake.
Tomas
basti mailingl...@unix-solution.denapsal/a:
Hello
17:09 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$
Basti
On 22.04.2014 16:32, Adrian Klaver wrote:
On 04/22/2014 07:11 AM, basti wrote:
When Postgres has no permission why pgstat.stat is created by postgres
-rtl
-rw--- 1 postgres postgres 312211 Apr 22 11:31 pgstat.stat
There is no /run/shm/pgstat.tmp file but if I create it and change the
owner to postgres the file will be removed few minutes later.
How can explain and how can I solve this error?
Regards,
Basti
--
Sent via pgsql-general
/run/shm and /var/run/shm would be the same. On my system I found no
symlink to each other but there is the same content.
Basti
On 22.04.2014 12:02, Tomáš Vondra wrote:
Seems you're using /run/shm and /var/run/shm by mistake.
Tomas
basti mailingl...@unix-solution.denapsal/a:
Hello
are enough.
Basti
On 22.04.2014 15:36, Adrian Klaver wrote:
On 04/22/2014 02:39 AM, basti wrote:
Hello,
since I have enabled stats_temp_directory = '/run/shm' in
/etc/postgresql/9.1/main/postgresql.conf I get the following error:
2014-04-21 02:37:29 CEST LOG: could not rename temporary
17:09 pgstat.stat
-rw-r--r-- 1 root root 0 Oct 19 2012 .tmpfs
postgres@srv1:/home/postgresql_data/postgresql/9.1/main/pg_log$
Basti
On 22.04.2014 16:32, Adrian Klaver wrote:
On 04/22/2014 07:11 AM, basti wrote:
When Postgres has no permission why pgstat.stat is created by postgres
Hello,
at the moment we use a Postgres Server as Master and one as Hot-Standby.
The Database is around 50GB and will massive grow next time.
Backup and Restore with pg_dump take several hours, is there a faster
way to do this?
Regards,
Basti
--
Sent via pgsql-general mailing list (pgsql
Hello,
at the moment we use a Postgres (9.1) Master and a Hot-Standby with WAL
Replication.
We also use Slony to copy some (not all) Tables to fronted server.
Is it possible to use repmgr to switch between Master and Hot-standby
without lose the slony functionality?
When I use repmgr and switch
Thanks a lot!
Basti
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
release (9.2.4, 9.1.9 or 9.0.13).
On 17.03.2014 12:12, Tomas Vondra wrote:
Hi,
On 17 Březen 2014, 11:45, basti wrote:
Hello,
we have a database master Version:
PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-2) 4.7.2, 64-bit
and a WAL-Replication Slave with hot
50 matches
Mail list logo