Steven Hirsch writes:
> I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory
> as a peer to the 'data' directory I specified at database initialization.
> What is this directory for and what parameter determines its location?
Postgres itself certainly does no such thing. Ma
On Tue, Oct 25, 2016 at 06:03:43PM -0400, Steven Hirsch wrote:
> I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory as
> a peer to the 'data' directory I specified at database initialization. What
> is this directory for and what parameter determines its location?
I am guessi
I notice that PostgreSQL (both 9.5.4 and 9.6) create a 'data2' directory
as a peer to the 'data' directory I specified at database initialization.
What is this directory for and what parameter determines its location?
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
On 10/24/2016 11:08 AM, Ankit Sablok wrote:
Thanks for replying Tom and Asif, I think the issue was that libpq.so
present in the /pgsql/lib directory did not have all its dependencies
installed on the system namely openssl hence I execute the command
sudo yum install openssl and that proceeded
Hi Ankit,
You might have specific requirements to need PG 9.6. But if 9.5 is
sufficient, it will be easier to simply do a rpm/yum install.
Regards,
Daniel
On Tue, Oct 25, 2016 at 4:08 AM, Ankit Sablok wrote:
> Thanks for replying Tom and Asif, I think the issue was that libpq.so
> present in t
Sure you're right... my oversight, sorry. I wanted only to create a
situation in which the standby remains quite behind with updates, so we
can suppose that there is a list of standby servers (so the primary
keeps going on with the 2nd) or simply suppose the replication async.
Pupillo
Il 25/10
I may be confused but...
On Tue, Oct 25, 2016 at 5:08 PM, t.dalpo...@gmail.com
wrote:
> These servers are configured for Sync streaming replication .
> Let's suppose that the standby stays down for a long time, then it restarts,
Doesn't sync replication plus standby down mean primary will stop
a
HI:
You can use windows functions. https://www.postgresql.org/
docs/9.5/static/tutorial-window.html
specifically row_number(). https://www.postgresql.org/
docs/9.5/static/tutorial-window.html
I'm assuming that your ordering is based on lname and then fname.
The query for getting 'number' is
san
> On 25 Oct 2016, at 17:06, Mark Lybarger wrote:
>
> I want to update a table to have the value of the occurrence number. For
> instance, I have the below table. I want to update the number column to
> increment the count of last name occurrences, so that it looks like this:
>
> first last
On Tuesday 25 October 2016 17:08:26 t.dalpo...@gmail.com wrote:
> Hi,
> let's suppose I have:
> - a primary server with its own local archive location, configured for
> continuous archiving
> - a standby server without archive.
> These servers are configured for Sync streaming replication .
> L
Hi,
let's suppose I have:
- a primary server with its own local archive location, configured for
continuous archiving
- a standby server without archive.
These servers are configured for Sync streaming replication .
Let's suppose that the standby stays down for a long time, then it
restarts,
I want to update a table to have the value of the occurrence number. For
instance, I have the below table. I want to update the number column to
increment the count of last name occurrences, so that it looks like this:
first last 1
second last 2
third last 3
first other 1
next other 2
Here's my
12 matches
Mail list logo