On Thu, Jul 2, 2015 at 11:50 AM, Vick Khera wrote:
>
> On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh
> wrote:
>
>> With my dataset I have been able to take advantage of the L2ARC.
>> Currently using about 80GB on ARC and 260GB on L2ARC. With the ARC
>> currently having the greater Hit ratio.
>
On Thu, Jul 2, 2015 at 10:56 AM, Joseph Kregloh
wrote:
> With my dataset I have been able to take advantage of the L2ARC. Currently
> using about 80GB on ARC and 260GB on L2ARC. With the ARC currently having
> the greater Hit ratio.
>
Did you tell postgres that the effective_cache_size = Shared
On Thu, Jul 2, 2015 at 9:35 AM, Vick Khera wrote:
>
> On Wed, Jul 1, 2015 at 5:07 PM, Joseph Kregloh
> wrote:
>
>> We recently built a new server for our Production database. The machine
>> is top of the line with 128GB of RAM, dual E5-2650. We also included NVME
>> drives for ZIL and L2ARC. Cur
On Wed, Jul 1, 2015 at 5:07 PM, Joseph Kregloh
wrote:
> We recently built a new server for our Production database. The machine is
> top of the line with 128GB of RAM, dual E5-2650. We also included NVME
> drives for ZIL and L2ARC. Currently we have 3 zpools. First one holds the
> FreeBSD install
We recently built a new server for our Production database. The machine is
top of the line with 128GB of RAM, dual E5-2650. We also included NVME
drives for ZIL and L2ARC. Currently we have 3 zpools. First one holds the
FreeBSD install. Second holds the jails, and third holds all of the
database da
Keith D. Evans wrote:
We usually run postgresql on a private machine (gravity) but due to
space, we have moved the database to a different machine through afs (a
local network at the university). We do not want the private machine to
be accessible to outside users, so our web pages are on the u
On Thu, May 21, 2009 at 1:04 PM, Scott Marlowe wrote:
> On Thu, May 21, 2009 at 12:23 PM, Keith D. Evans wrote:
>> We usually run postgresql on a private machine (gravity) but due to space,
>> we have moved the database to a different machine through afs (a local
>
> Wait, the whole database, inc
On Thu, May 21, 2009 at 12:23 PM, Keith D. Evans wrote:
> We usually run postgresql on a private machine (gravity) but due to space,
> we have moved the database to a different machine through afs (a local
Wait, the whole database, including a postmaster running on the other
machine? Or just tha
In your application, the connection string should have the ip address of the
postgres server. The postgres server (solaris box) should allow port 5432
through the firewall.
If you cannot access port 5432 on your solaris box from the linux box,
then make sure that you don't have a firewall in th
We usually run postgresql on a private machine (gravity) but due to
space, we have moved the database to a different machine through afs (a
local network at the university). We do not want the private machine to
be accessible to outside users, so our web pages are on the university's
public web
On 21/05/2009 18:49, Keith D. Evans wrote:
> The database is on a public machine (Linux), but the postgresql
> postmaster runs on a private machine (Solaris 10).
That doesn't make a lot of sense, unless you've got *two* postmasters
running, one on each machine, or maybe you've created a tablespac
On Thu, 2009-05-21 at 13:49 -0400, Keith D. Evans wrote:
> Joshua,
>
> Let me rephrase what I wrote. The database is on a public machine
> (Linux), but the postgresql postmaster runs on a private machine
> (Solaris 10). Can we access the postgresql database through the public
> machine, even t
Joshua,
Let me rephrase what I wrote. The database is on a public machine
(Linux), but the postgresql postmaster runs on a private machine
(Solaris 10). Can we access the postgresql database through the public
machine, even though the postmaster is running from a (different)
private machine?
> So, the question is, can someone go through these (public) web pages and
> access the postgresql database if the postgresql server is running on
> the private machine?
>
> We have other data in the postgresql and would like to only have to use
> one database types, i.e., postgresql.
If you
We have a private machine that runs postgresql and have created a
database. We want to access that database from the web for plotting
using php. The web server and pages are on a public (different) machine
that does not have postgresql. Nor will they install it for is. The
postgresql database i
Glen Eustace escribió:
>
>> Generally speaking, virtualization allows you to take a bunch of low
>> powered servers and make them live in one big box saving money on
>> electricity and management. Generally speaking, database sers are big
>> powerful boxes with lots of hard disks and gigs upon gig
Glen Eustace wrote:
> Hi all,
>
> I was wondering whether anyone has had any experience running postgresql
> in a vm under ESx. VMware provides significant HA/DR oppurtunities and
> we would like to use it if we can. The DBase would be on a EMC SAN
> hosted LUN and the ESx servers would be dual
On Sun, Nov 23, 2008 at 6:47 PM, Glen Eustace <[EMAIL PROTECTED]> wrote:
>
>> Generally speaking, virtualization allows you to take a bunch of low
>> powered servers and make them live in one big box saving money on
>> electricity and management. Generally speaking, database sers are big
>> powerf
Generally speaking, virtualization allows you to take a bunch of low
powered servers and make them live in one big box saving money on
electricity and management. Generally speaking, database sers are big
powerful boxes with lots of hard disks and gigs upon gigs of ram to
handle terabytes of da
On Sun, Nov 23, 2008 at 5:28 PM, Glen Eustace <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I was wondering whether anyone has had any experience running postgresql in
> a vm under ESx. VMware provides significant HA/DR oppurtunities and we
> would like to use it if we can. The DBase would be on a EMC
Hi all,
I was wondering whether anyone has had any experience running postgresql
in a vm under ESx. VMware provides significant HA/DR oppurtunities and
we would like to use it if we can. The DBase would be on a EMC SAN
hosted LUN and the ESx servers would be dual Quad CPU HP DL-380/G5s. At
Charles <[EMAIL PROTECTED]> writes:
> I am running Gutsy (Ubuntu 7.10) and new to Postgresql. I followed the
> direction at https://help.ubuntu.com/community/PostgreSQL. I executed
> the following commands:
> sudo -u postgres createuser -D -A -P myuser
> sudo -u postgres createdb -O myu
On Nov 5, 2007, at 12:36 PM, Charles wrote:
I am running Gutsy (Ubuntu 7.10) and new to Postgresql. I followed the
direction at https://help.ubuntu.com/community/PostgreSQL. I executed
the following commands:
sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -
Well it defaults to mapping to the current user, so you would have wanted:
psql -U myuser mydb
Or just create a postgres user named dagon and create the db as owned by
that user. Or su myuser before running psql...
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
I am running Gutsy (Ubuntu 7.10) and new to Postgresql. I followed the
direction at https://help.ubuntu.com/community/PostgreSQL. I executed
the following commands:
sudo -u postgres createuser -D -A -P myuser
sudo -u postgres createdb -O myuser mydb
[EMAIL PROTECTED]:~$ psql
My database needs are probably less than yours, but I've had zero
issues running postgres inside a domU. I'm not using SAN, but instead
DRBD to replicate data at the block level between dom0s. I haven't
tried migrating the domU from one machine to another without
rebooting it, but the shutd
What I'm not sure of:
- Maybe it's better to run PGSQL in Dom0, on 2 different Xen units that
are beefed up, with a few lighter DomU guest OSs running in the
background. Some sort of heartbeat software that allows the 2 Xen units
to grab the PGSQL's IP address as needed.
PostgreSQL perfor
We're slowly trying to move away from hardware dependence for our
servers and it looks like Xen is the path. Our primary goal is that if
a particular server fails, we can simply migrate the guest OSs to
another Xen node and the users will not experience any downtime. Plus
it should allow us t
Thomas LeBlanc wrote:
How to I run PostgreSQL on an Intel machine with Windows?
Hi Thomas,
This is probably the page you want:
http://techdocs.postgresql.org/guides/Windows
:-)
Regards and best wishes,
Justin Clift
---(end of broadcast)---
TIP 1: subs
How to I run PostgreSQL on an Intel machine with Windows?
Thanks,
Thomas
_
MSN Movies - Trailers, showtimes, DVD's, and the latest news from Hollywood!
http://movies.msn.click-url.com/go/onm00200509ave/direct/01/
Jeff Davis <[EMAIL PROTECTED]> writes:
> I have virtual hosted users on a server and some of them have a
> postgresql database. I'm concerned about the outside possibility that a
> user could create an infinite loop and fill up the partition on which
> everyone's database resides.
It seems like
Jeff Davis wrote:
Anyway, it occured to me that I could create a special file for each
database user of limited size, and make a filesystem on top of that
file. The file could be owned by the user. Then, each user could have a
seperate database and that database would be at the location of the
moun
I have virtual hosted users on a server and some of them have a
postgresql database. I'm concerned about the outside possibility that a
user could create an infinite loop and fill up the partition on which
everyone's database resides.
Anyway, it occured to me that I could create a special file fo
I keep seeing the following whenever there is a new client connection to the
database:
Error semaphore semaphore not equal 0
anyone know what this means? Thanks.
- Greg
34 matches
Mail list logo
