. As far as I am aware, MS SQL server provides this
mechanism while PostgreSQL does not. And for this reason, I would
certainly encourage using PostgreSQL's backup mechanisms for business
critical applications.
I just spoke with several admins who were not aware of these differences
betwee
ed space for a complete backup.
But you are right: if you can ensure that pg_basebackup has finished prior to
making a backup of the virtual machine, this is certainly safe.
Klaus
---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus
--
n the snapshot.
I may be wrong, but my understanding of a VSS writer is that all transaction
and log files are flushed to disk prior tot he snapshot.
Klaus
---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus
--
Sent via pgsql-general mai
r is most likely "no, it is not safe".
Regards, Klaus
---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
(introduced with server 2012 and providing some new features
like automatic integrity checks, clustering etc.) does no longer provide
hard links.
Are hard links used anywhere else but in pg_upgrade?
Klaus
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
Running PostgreSQL 9.6 on a Windows Server.
Table "t" is kind of a materialized view with > 100 columns and 2.24 Mio
rows. Queries are generated by an ORM framework - fairly difficult to
modify.
Vacuum analyze was carried out - no impact.
The framework generates queries like this:
sel
A similar result was achieved by return a dummy ID from the function for
records without country.
Any idea why the functional index does not work in a LEFT JOIN query?
Thanks Klaus
Von: Jeff Janes [mailto:jeff.ja...@gmail.com]
Gesendet: Dienstag, 21. März 2017 08:22
An: Klaus P.
l.conf without luck.
A sequential scan on the order table alone is carried out in 15 ms.
Thanks for any idea.
Klaus
atest version of pgadmin III seems to work after a couple of error
messages during the start.
Thanks Klaus
I'm using the setting "Toolchain: Visual Studio 2010" for C language
extensions.
Is this still correct for the current versions?
Thanks Klaus
- Can triggers be used to catch constraint violations?
My least preferred solution would by the replication software handling an
exception.
Thanks
Klaus
A rule?
- Can triggers be used to catch constraint violations?
My least preferred solution would by the replication software handling an
exception.
Thanks
Klaus
---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus
reSQL.
For me is the way Sybase works is just more convenient:
CREATE MyTable (MyColumn varchar);
creates a camel cased table MyType and field MyColumn.
SELECT * FROM SYSCATALOG gives MyTable.
This is better readable when you use long table / fiel names.
The user can then use whatever he wants
experience is however that the statements are carried out sequentially.
Thanks
Klaus Pieper
Hi Guillaume splendid - tx! ./k
On 17/11/2014 22:53, Guillaume Lelarge wrote:
Le 17 nov. 2014 22:49, "Klaus Hofeditz
]project-open[" <klaus.hofed...@project-open.com>
a écrit :
>
> Hi guys,
>
where
table_name like '%Trans%';
table_name
TransTasksCube
(1 row)
Appreciate your help!
Klaus
--
Klaus Hofeditz
Co-Founder ]project-open[
Web: http://www.project-open.com
http://
select current_user;
On Thu, Jan 30, 2014 at 3:53 PM, Adrian Klaver wrote:
> On 01/30/2014 06:13 AM, Ovid wrote:
>
>> First: CREATE ROLE and CREATE DATABASE;
>>>
>>
>> After: CREATE TABLEs;
>>>
>>
>> Last: GRANT SELECT,INSERT,UPDATE and DELETE.
>>>
>>
>> OK, I dropped the database. Since I hav
well, in your statement, the parameters are missing.
2013-08-05 10:18:01 STATEMENT: select distinct count(*) as rownum from
minta as m join partner as p on ( m.partnerid = p.partnerid ) join
mintajelleg as mj on ( mj.mintajellegid = m.mintajellegid ) where
m.status IN and m.mintajellegid =
No, it's super frustrating. While I do the recovery, it says it reaches a
consistent recovery state, and i just cannot find a way how to convince pg
to stop at that state:
2013-08-02 09:23:25 GMT DEBUG: postgres: PostmasterMain: initial
environment dump:
2013-08-02 09:23:25 GMT DEBUG:
29:09 UTC <%> LOG: database system is ready to accept
connections
well, that does not indicate anything for me.
On Wed, Jul 31, 2013 at 9:37 AM, Albe Laurenz wrote:
> Klaus Ita wrote:
> > I have restored a Database Cluster with a recovery_target_time set to
> >
> >
4.7.2-5) 4.7.2, 64-bit
(1 row)
somewhat irrelevant, as my question is more general?
thank you for your help!
klaus
7;s an lsi
controller, ... not fond of it, but it's not bad stuff.
lg,k
On Tue, Jul 30, 2013 at 5:29 PM, bricklen wrote:
>
> On Tue, Jul 30, 2013 at 8:18 AM, Klaus Ita wrote:
>
>>
>> thank you! It turned out that really there was a corruption in the main
>> pg server
7;d be safe.
lg,k
On Tue, Jul 30, 2013 at 5:13 PM, bricklen wrote:
> On Mon, Jul 29, 2013 at 11:50 PM, Klaus Ita wrote:
>
>> I am trying to remember, there was a tool that plotted the contents of
>> the wal_files in a more readable format ...
>>
>
> xlogdump?
>
> https://github.com/snaga/xlogdump
>
ly
session-logging/statistics data).
I am trying to remember, there was a tool that plotted the contents of the
wal_files in a more readable format ...
lg,k
On Tue, Jul 30, 2013 at 8:23 AM, raghu ram wrote:
>
> On Tue, Jul 30, 2013 at 4:07 AM, Klaus Ita wrote:
>
>> Sorry for cros
should cause streaming
replication to
# end (i.e., failover).
trigger_file = '/var/lib/postgresql/9.1/main/stop_replication_trigger'
cannot currently to psql 'select version()' as the beast won't startup ;(,
but it's
ii postgresql-9.1 9.1.9-1
amd64object-relational SQL database, version 9.1 server
thank you,
klaus
.pl --file_path=%p
--file_name=%f --work_dir=/var/tmp/ --destination_hosts=
va-pg-back...@dx.ipv6.ex.net
--destination_sftp_hosts=u671@ipv6.u71.y--destination_hosts=
va-pg-back...@y7.ipv6.ex.net'
max_wal_senders = 3 # max number of walsender processes
wal_keep_segments = 50 # in logfile segments, 16MB each; 0 disables
thx in advance,
klaus
Postgres 8.4.9 on CentOS
I partitioned some tables over the weekend by month using a date field as the
partitioning column. Table inheritance was used and all indexes on the parent
were created on the partitions. constraint_exclustion = partition.
My question is, are partitions really
Postgres 8.4.9 on CentOS
I partitioned some tables over the weekend by month using a date field as
the partitioning column. Table inheritance was used and all indexes on the
parent were created on the partitions. constraint_exclustion = partition.
My question is, are partitions really gett
Updating: I found two other sessions running the same query. Once I killed them
the pg_tmp files were automatically deleted.
>>
This morning we found out that our filesystem was at 98% and filling quickly.
We immediately found one query running for a long time and saw 1500+ files in
the pg
, February 05, 2013 12:07 PM
To: Robert Klaus
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] cleanup of pgsql_tmp directory
"Robert Klaus" writes:
> This morning we found out that our filesystem was at 98% and filling
> quickly. We immediately found one query running for
This morning we found out that our filesystem was at 98% and filling
quickly. We immediately found one query running for a long time and saw
1500+ files in the pgsql_tmp directory we could attribute to it.
I killed using pg_terminate_backend and some space was reclaimed, but the
temporary f
, 2013 11:31 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Large number of rows in pg_type and slow gui
(pgadmin) refresh
Robert Klaus wrote on 03.01.2013 16:50:
> We have 36,000+ rows returned by " SELECT oid, format_type(oid,
> typtypmod) AS typname FROM pg_type".
>
We have 36,000+ rows returned by " SELECT oid, format_type(oid, typtypmod)
AS typname FROM pg_type".
My manager says this is only a small number compared to what is expected by
next summer.
When I run this select statement on the database server it returns in under
1 second but it takes a m
, inserts, updates)
Taking your advice on upgrading both OS and pg version. I'll be back if
that does not solve the issue ;-)
Thanks for your time.
-Rob
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 10, 2004 2:30 PM
To: Rob Klaus
Cc: [EMAIL PROT
on system? Are there any PostgreSQL
specifics or limitations? Significant differences between these two
languages?
Any input will be apprecíated,
Klaus
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
35 matches
Mail list logo
