On 04/23/2018 08:09 PM, Andrew Edenburn wrote:
> I am having issues with my PAF setup. I am new to Postgres and have setup the
> cluster as seen below.
>
> I am getting this error when trying to start my cluster resources.
>
>
>
> Master/Slave Set: pgsql-ha [pgsqld]
>
> pgsqld (ocf
Thank you for the explanation. I have rearranged my query and it works now
(surprisingly fast too) -
On Mon, Apr 23, 2018 at 9:58 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Mon, Apr 23, 2018 at 12:47 PM, Alexander Farber <
> alexander.far...@gmail.com> wrote:
>
>>
Il 24/04/2018 04:09, Dale Seaburg ha
scritto:
Thanks to Moreno and Igor for the Event Viewer suggestions.
Here are a few lines of log file where they differ between a
good install and a bad incomplete install. The good install was
fr
I have done some big contracts for large financial companies, and for most
of them, ANY changes to the DB structure required extensive 3rd party
testing and a change control process that sometimes took weeks.
But we did get a waiver for the use of DB 'code' like stored procedures and
views, which
Hi there:
I want to ask the if I could define an object like type in postgresql, it may
be better to illustrate with actual examples.
Background information:
1, I would like to pack group of data into 1 entry of in a table.
2, The table consist some financial product information in
On Tue, Apr 24, 2018 at 4:53 AM, a <372660...@qq.com> wrote:
> Hi there:
>
> I want to ask the if I could define an object like type in postgresql, it
> may be better to illustrate with actual examples.
>
> Background information:
>
> 1, I would like to pack group of data into 1 entry of in a
On 04/23/2018 08:59 AM, yogeshr wrote:
Our client has provided us Red Hat machine for setting up PostgreSQL. We are
allowed to install red hat provided packages only.
What version of RH?
So we have to install red hat provided postgresql (rh-postgresql96) instead
of postgresql-9.6.
Is it a g
From: Dale Seaburg [mailto:kg...@verizon.net]
Sent: Monday, April 23, 2018 10:10 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: Strange error in Windows 10 Pro
Thanks to Moreno and Igor for the Event Viewer suggestions. Here are a few
lines of log file where they differ between a good in
On Sun, Apr 8, 2018 at 15:37 g...@luxsci.net wrote:
>
>
> On April 8, 2018 02:40:46 pm PDT, "Guyren Howe" wrote:
>
> One advantage to using logic and functions in the db is that you can fix
> things immediately without having to make new application builds. That in
> itself is a huge advantage,
Hi: I need some advise on how best to backup a PG DB.
PG 9.5.2 on RHEL6
The requirement is to be able to restore the DB after catastrophic failure
and lose no more than the last 15 minutes worth of data. Also, we would
like to be able to do the backups on-line (no down time). There is no need
f
On Mon, 23 Apr 2018 18:09:43 +
Andrew Edenburn wrote:
> I am having issues with my PAF setup. I am new to Postgres and have setup
> the cluster as seen below. I am getting this error when trying to start my
> cluster resources.
> [...]
>
> cleanup and clear is not fixing any issues and I am
On 04/24/2018 07:50 AM, David Gauthier wrote:
Hi: I need some advise on how best to backup a PG DB.
PG 9.5.2 on RHEL6
The requirement is to be able to restore the DB after catastrophic
failure and lose no more than the last 15 minutes worth of data. Also,
we would like to be able to do the b
On Tue, Apr 24, 2018 at 10:50 AM, David Gauthier
wrote:
> Typically, I would think doing a weekly full backup, daily incremental
> backups and turn on journaling to capture what goes on since the last
> backup.
>
This is almost the whole concept of the streaming replication built into
postgres,
Charlin Barak wrote:
> We will be developing three new applications in PostgreSQL, each having its
> own
> database instance running on different hosts. We will only have one schema per
> Postgres instance. The data is read-write only by one application/schema in
> the
> DB instance and the data
I have meet the similar issue when the postgres is not stopped normally.
You could run pg_controldata to check if your postgres status is
shutdown/shutdown in recovery.
I change the /usr/lib/ocf/resource.d/heartbeat/pgsqlms to avoid this problem:
elsif ( $pgisready_rc == 2 ) {
# The instance
On 04/24/2018 10:06 PM, Adrian Klaver wrote:
> On 04/23/2018 08:59 AM, yogeshr wrote:
(...)
>> Also, we were trying to set up repmgr for this PostgreSQL in the local
>> environment but we didn't find any suitable package for this PostgreSQL.
>
> That is something you are going to have to talk over
Hi all,
I have a user table with ~8M records, with different type of fields b-tree
indexed.
by investigating index sizes, i found two strange things:
1- all index sizes are almost the same, regardless of field type (boolean,
string, bigint)
2 - all of them are much bigger that my expectation, e.g.
The normal input function for variables with properties of {internallength!=
variable, storage=plain/main}, the return type will be Datum.
The definition of Datum is "unsigned __int64" which may only consist the
address of pointed data.
For data with variable length, the length of the data is
18 matches
Mail list logo
