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
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
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
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
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
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
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
26 matches
Mail list logo
