On 11/6/2017 5:28 AM, Vikas Sharma wrote:
I am having issues in starting up postgresql service on RHEL 6.8, It
was all working fine yesterday but now it doesn't start and throws
error - same kind of error that is received connecting to remote
postgres database.
what /exact/ error is it throwi
Hi,
I am having issues in starting up postgresql service on RHEL 6.8, It was
all working fine yesterday but now it doesn't start and throws error - same
kind of error that is received connecting to remote postgres database.
for the meantime I have started postgresql as below -
/usr/pgsql-9.3/bin/
Hi,
I am trying to uninstall PostgreSQL 9.3 from a Windows 2012 server using
the *uninstall-postgresql.exe*. During the uninstall, I get an error:
*The uninstall-postgresql.dat file cannot be found and is required to
uninstall the application, aborting. Uninstallation did not complete
successfull
On 1/7/2016 12:41 PM, balajishanmu...@live.in wrote:
For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I
am yet to get the log. I will post the Postgres log once I have it.
is this an enterprise grade SSD with supercap backup? or is it a
consumer desktop/notebook class
On Thu, Jan 7, 2016 at 1:41 PM, balajishanmu...@live.in
wrote:
> Hi,
>
> For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I
> am yet to get the log. I will post the Postgres log once I have it.
>
> Thanks!
Yeah a lot of cheaper consumer grade SSDs don't fsync safely. Ther
Hi,
For storage I am using a 2.5inch SATA 3 SSD hard disk. It is about 60 GB. I
am yet to get the log. I will post the Postgres log once I have it.
Thanks!
--
View this message in context:
http://postgresql.nabble.com/Postgresql-9-3-not-coming-up-after-restart-in-centos-tp5880435p5880957.htm
On Wed, Jan 6, 2016 at 2:08 PM, balajishanmu...@live.in
wrote:
> Most of the time I will be restarting centOS by issuing reboot command. Which
> will do the orderly shutdown of all the service and sometimes just pull the
> plug.
>
> But the issue appears to be random. Is there a way that before Po
On 01/06/2016 01:08 PM, balajishanmu...@live.in wrote:
Most of the time I will be restarting centOS by issuing reboot command. Which
will do the orderly shutdown of all the service and sometimes just pull the
plug.
But the issue appears to be random. Is there a way that before Postgres
starts we
Most of the time I will be restarting centOS by issuing reboot command. Which
will do the orderly shutdown of all the service and sometimes just pull the
plug.
But the issue appears to be random. Is there a way that before Postgres
starts we can check whether data is flushed, if not flush it manua
On Wed, Jan 6, 2016 at 12:36 PM, balajishanmu...@live.in
wrote:
> By application I mean centOS.
>
> We are starting and stopping Postgres using systemd service. We have a
> service file called postgresql9.3.service which is used to start or stop
> Postgres.
>
> Excerpts of postgresql9.3.service
>
By application I mean centOS.
We are starting and stopping Postgres using systemd service. We have a
service file called postgresql9.3.service which is used to start or stop
Postgres.
Excerpts of postgresql9.3.service
ExecStartPre=/usr/pgsql-9.3/bin/postgresql93-check-db-dir ${PGDATA}
ExecStart=
On 01/05/2016 11:18 AM, balajishanmu...@live.in wrote:
Hi
I have installed postgresql-9.3 in my centos application. When the
application starts for first-time Postgres starts without any issue most of
Not sure what you are talking about when you say CentOS application.
Are you saying when Cen
Hi
I have installed postgresql-9.3 in my centos application. When the
application starts for first-time Postgres starts without any issue most of
the time. But when I reboot the centOs, Postgres is not getting started on
subsequent boot and I am getting the error,
LOG: invalid magic number
On 12/12/15 2:08 PM, Shay Cohavi wrote:
> *I have postgresql 9.3 setup with 2 nodes (active/standby with streaming
> replication & continuos archiving).*
> *I have created 2 failover & failback script in order to perform a
> switchover between the DB servers:*
> *1. failover - create a trigger file
*Hi,*
*I have postgresql 9.3 setup with 2 nodes (active/standby with streaming
replication & continuos archiving).*
*I have created 2 failover & failback script in order to perform a
switchover between the DB servers:*
*1. failover - create a trigger file in order to promote the new primary.*
*2. f
Hi everyone,
I am trying to setup postgresql 9.3 hotstandby replication server. I am
getting error incorrect checksome in control file. both server have below
version and pg package version and both are 64 bit processor.
OS is : Debian squeeze
PG version:- postgresql-9.3
Only difference is re
Genereal advice is to set up shared_buffers to 25% of total RAM. 75% RAM
for OS cache.
On my case (1.5 TB database, 145 GB RAM), setting shared_buffers bigger
than 8GB would give no significant performance impact.
On some cases, setting it low would be an advantage
http://www.depesz.com/2007/12/05/
Hello all,
Iam running a postgresql 9.0.13 master/slave instance in a write heavy
workload.
The hardware is a Dell 720, E5530 - 8 core, 128GB RAM. The database (around
250g with indexes/bloat etc) is sitting on flashcache device with 2 fusion-
io PCIe MLC SSDs as frontend and a MD3200 based RAID1
Hi,
Thanks. So we are close to the tentative release date. Good.
Regards,
Jayadevan
On Mon, Aug 19, 2013 at 10:16 AM, Sandro CAZZANIGA <
cazzaniga.san...@gmail.com> wrote:
> Le 19/08/2013 06:38, Jayadevan M a écrit :
> > Hello all,
> > Is the release date for PostgreSQL 9.3 production decided? W
Le 19/08/2013 06:38, Jayadevan M a écrit :
> Hello all,
> Is the release date for PostgreSQL 9.3 production decided? We are going
> live in a couple of weeks with a portal and if possible, would like to
> go with 9.3, Materialized Views being the key feature that will add value.
> Regards,
> Jayade
Le 19/08/2013 06:38, Jayadevan M a écrit :
> Hello all,
> Is the release date for PostgreSQL 9.3 production decided? We are going
> live in a couple of weeks with a portal and if possible, would like to
> go with 9.3, Materialized Views being the key feature that will add value.
> Regards,
> Jayade
Hello all,
Is the release date for PostgreSQL 9.3 production decided? We are going
live in a couple of weeks with a portal and if possible, would like to go
with 9.3, Materialized Views being the key feature that will add value.
Regards,
Jayadevan
Hi All,
Greetings for the day.
Recently, I have installed the PostgreSQL 9.3 on my local ubuntu machine
for testing the new features in PG 9.3. I have created few test tables as
well. Now, I am trying to take the dump from the 9.3 binaries and getting
the below error.
postgres@test-ubuntu:/opt/P
23 matches
Mail list logo