On Mon, Oct 1, 2012 at 7:28 AM, pfote wrote:
> Hi,
>
> I had a very strange effect on the weekend that smells like a bug, so i'd
> like so share it.
>
> Setup:
> machine A: 16 CPU Cores (modern), 128GB RAM, nice 6-drive SAS Raid-10
> machines B, C: 8 Cores (substantially older than A), 48GB Ram, s
On Fri, Oct 12, 2012 at 7:44 AM, Chitra Creta wrote:
> Hi,
>
> I currently have a table that is growing very quickly - i.e 7 million
> records in 5 days. This table acts as a placeholder for statistics, and
> hence the records are merely inserted and never updated or deleted.
>
> Many queries are
pg_upgrade has worked fine for several releases. I believe that the
only time when pg_upgrade isn't a viable option is for some types of
GIST indices.
On Mon, Oct 22, 2012 at 2:55 PM, Nikolas Everett wrote:
> I was just looking at
> http://www.postgresql.org/docs/devel/static/release-9-2.html an
On Wed, Oct 31, 2012 at 10:32 AM, Edson Richter
wrote:
> I've two PostgreSQL 9.1.6 running on Linux CentOS 5.8 64bit.
> They are replicated asynchronously.
>
> Yesterday, I've dropped a database of 20Gb, and then replication has broken,
> requiring me to manually synchronize both servers again.
>
On Wed, Oct 31, 2012 at 11:01 AM, Edson Richter
wrote:
> Em 31/10/2012 15:39, Lonni J Friedman escreveu:
>>
>> On Wed, Oct 31, 2012 at 10:32 AM, Edson Richter
>> wrote:
>>>
>>> I've two PostgreSQL 9.1.6 running on Linux CentOS 5.8 64bit.
>>>
On Mon, Nov 5, 2012 at 2:02 PM, Thalis Kalfigkopoulos
wrote:
> Hi all,
>
> I read somewhere that the following query gives a quick estimate of the # of
> rows in a table regardless of the table's size (which would matter in a
> simple SELECT count(*)?):
>
> SELECT (CASE WHEN reltuples > 0 THEN
> p
On Mon, Nov 5, 2012 at 3:56 PM, Thalis Kalfigkopoulos
wrote:
>
> On Mon, Nov 5, 2012 at 7:14 PM, Lonni J Friedman wrote:
>>
>> On Mon, Nov 5, 2012 at 2:02 PM, Thalis Kalfigkopoulos
>> wrote:
>> > Hi all,
>> >
>> > I read somewhere that the foll
On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote:
> I had a 9.0.8 hot standby setup, one master, two slaves, working great.
> Then, I tried to re-initialize by making a base backup, the way I've done it
> many times before, but for some reason I can't get the standby to accept
> connections. I c
On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote:
>
>
> On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman wrote:
>>
>> On Mon, Nov 5, 2012 at 7:40 PM, Ian Harding wrote:
>> > I had a 9.0.8 hot standby setup, one master, two slaves, working great.
>> > The
On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote:
>
>
>
> On Mon, Nov 5, 2012 at 7:57 PM, Lonni J Friedman wrote:
>>
>> On Mon, Nov 5, 2012 at 7:49 PM, Ian Harding wrote:
>> >
>> >
>> > On Mon, Nov 5, 2012 at 7:46 PM, Lonni J Friedman
>
On Mon, Nov 5, 2012 at 8:31 PM, Ian Harding wrote:
>
>
>
> On Mon, Nov 5, 2012 at 8:15 PM, Lonni J Friedman wrote:
>>
>> On Mon, Nov 5, 2012 at 8:13 PM, Ian Harding wrote:
>> >
>> >
>> >
>> > On Mon, Nov 5, 2012 at 7:57 PM, Lonni J F
On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery wrote:
> We have a test 9.2.0 db running on openSuse 12.2. When I select now() I get
> the correct timezone and date back (-5 hours).
> When I do date at the os prompt, I get the right timezone back.
>
> I changed postgres.conf to have timezone = 'E
On Tue, Dec 4, 2012 at 2:42 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> On Tue, Dec 4, 2012 at 1:59 PM, Bryan Montgomery wrote:
>>> I changed postgres.conf to have timezone = 'EST' and restarted postgres.
>>> However the log file is still 5 hours
I'm no expert on this, but it will likely be more helpful to others if
you include the table description with all the indices.
On Tue, Dec 4, 2012 at 8:44 PM, Edson Richter wrote:
> I've a table with >110 rows, with streets.
> I'm making a partial search using zip code, and PostgreSQL is igno
Greetings,
I've got an 8.1.10 instance running on Linux-i686. The system hosts 5
databases, all of which get vacuumed via a cronjob 3 times a day. All
of a sudden, the vacuum job for 1 of the databases is hanging
indefinitely. It normally finishes in under 5 minutes. There are no
errors in the
Greetings,
I'm running PostgreSQL-9.0.4 on a Linux-x86_64 cluster with 1 master,
and two streaming replication slaves. Since late yesterday, the load
on the server has been noticably higher (5.00+) than normal (generally
under 1.00). I investigated, and found that for the past ~18 hours,
there's
On Tue, Nov 22, 2011 at 6:57 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> When I strace PID 30188, I see tons of this scrolling past quickly,
>> but I'm not really sure what it means beyond a 'Timeout' not looking
>> good:
>> select(0, NULL, NULL, N
On Tue, Nov 22, 2011 at 7:19 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> Thanks for your prompt reply. I was pretty sure that I was using the
>> default, but just to confirm, I just ran:
>> 'SHOW vacuum_cost_delay;'
>
> What about autovacuum_vacuu
On Tue, Nov 22, 2011 at 7:49 PM, Tom Lane wrote:
> Lonni J Friedman writes:
>> I suspect you're right. I just ran strace against that PID again, and
>> now all the lseek & read FD's are referrring to a different number
>> (115), so that means its moved onto
Greetings,
I've got a PostgreSQL-9.0.x database that manages an automated testing
environment. There are a bunch of tables that contain assorted static
data (OS versions, test names, etc) named 'buildlist' & 'osversmap'.
However, there are also two tables which contain data which changes
often. T
On Thu, Dec 1, 2011 at 1:57 PM, David Johnston wrote:
> -Original Message-
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Lonni J Friedman
> Sent: Thursday, December 01, 2011 4:13 PM
> To: pgsql-general
> Subject: [
I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
streaming replication. I'm in the planning stages of upgrading to
9.1.x, and am looking into the most efficient way to do the upgrade
with the goal of minimizing downtime & risk. After googling, the only
discussion that I've found o
After reading this interesting article on shared_buffers and wal_buffers:
http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html
it got me wondering if my settings were ideal. Is there some way to
measure wal_buffer usage in real time, so that I could simply monitor
it for som
On Fri, Mar 16, 2012 at 2:45 AM, Albe Laurenz wrote:
> Lonni J Friedman wrote:
>> After reading this interesting article on shared_buffers and wal_buffers:
>> http://rhaas.blogspot.com/2012/03/tuning-sharedbuffers-and-walbuffers.html
>>
>> it got me wondering if my set
On Mon, Mar 19, 2012 at 12:30 PM, Bruce Momjian wrote:
> On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
>> I've got a 3 node cluster (1 master/2 slaves) running 9.0.x with
>> streaming replication. I'm in the planning stages of upgrading to
>>
On Tue, Mar 20, 2012 at 11:46 AM, Bruce Momjian wrote:
> On Mon, Mar 19, 2012 at 03:07:02PM -0700, Jeff Davis wrote:
>> On Mon, 2012-03-19 at 15:30 -0400, Bruce Momjian wrote:
>> > On Thu, Mar 01, 2012 at 02:01:31PM -0800, Lonni J Friedman wrote:
>> > > I'
Greetings,
I'm running postgresql-9.1.3 on a Linux-x86_64 (Fedora16, if it
matters) system. I noticed the existence of pg_basebackup starting in
9.1, and figured I'd try it out and see if it would simplify our
backup & management processes. I setup a test system (same OS &
postgresql version as p
On Fri, Apr 20, 2012 at 12:31 PM, Magnus Hagander wrote:
> On Fri, Apr 20, 2012 at 19:51, Lonni J Friedman wrote:
>> Anyway, lesson learned, I need to either invoke pg_basebackup as the
>> same user that runs the database (or is specified with the -U
>> parameter ?)
Greetings,
I'm running postgresql-9.1.3 on a Linux-x86_64 (Fedora16, if it
matters) system. I noticed the existence of pg_basebackup starting in
9.1, and figured I'd try it out and see if it would simplify our
backup & management processes.
$ pg_basebackup -P -v -D /tmp/backup -x -Ft -z -U postgr
On Wed, 23 Feb 2005 19:56:56 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > We have found that this query can indeed cause terrible things to
> > happen to postgresql - it can run several times with response times of
>
List & Tom,
Following up on this thread from a weeks ago:
http://archives.postgresql.org/pgsql-general/2005-02/msg00106.php
We have found that this query can indeed cause terrible things to
happen to postgresql - it can run several times with response times of
a few seconds, and then the next time
On Thu, 24 Feb 2005 22:46:02 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > Oh, also, do you see a time difference in running this query with &
> > without the genetic optimizer?
>
> Yeah, but that's no surp
On Fri, 25 Feb 2005 09:20:29 -0800, Si Chen <[EMAIL PROTECTED]> wrote:
> Thanks!
>
> Is there any documentation on how to upgrade to 8.0?
Dump your DB, install 8.0, reload your DB. Since you'e using RHEL3,
you should use the RPMs and it will be fairly easy.
> Is it possible to upgrade from 7.4
On Thu, 3 Mar 2005 11:07:53 -0800 (PST), Mark <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Simple question:
> If I change a hostname (Linux FC2) do I need to do any changes to
> Postgresql configurations ?
Only if the IP address associated with it is changing. Although
remote clients might need to have
On Mon, 7 Mar 2005 12:13:37 +0100, Ali B. <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I'm a new user (novice) of this database. I would like to optimise it...
> I've already created indexes...
> I see that it is possible to use 'Postmaster' in order to...
>
> But how can I use it? I don't know... I'm
On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <[EMAIL PROTECTED]> wrote:
> hello,
>
> Is it possible to restore a DB Schema in a different schema but in the
> same Database? or restore the schema with a different name? or restore
> a set of objects into a different schema from where they were
> b
schema, is it possible to restore the object to a different
> schema in the same database?
>
> thanks
>
> Hugo
>
> On Mon, 7 Mar 2005 09:54:04 -0800, Lonni J Friedman <[EMAIL PROTECTED]> wrote:
> > On Mon, 7 Mar 2005 13:42:48 -0400, Hugo Takada <[EMAIL PROT
On Tue, 8 Mar 2005 15:02:04 +0530, Sanjay Arora
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Can someone please tell me if & where rpm files for pgsql 8.1 for
> RH-ES3/whitbox linux can be found? Or do I have to compile?
8.1? I don't think that even exists yet. Did you mean 8.0.1 ?
ftp://ftp13.us.postg
On Wed, 09 Mar 2005 14:38:06 +0100, Ulrich Wisser
<[EMAIL PROTECTED]> wrote:
> Sorry,
>
> of course I forgot to mention my installed version. Please find them below:
>
> postgresql-jdbc-7.4.7-3.FC3.1
> postgresql-odbc-7.3-8.FC3.1
> postgresql-test-7.4.7-3.FC3.1
> postgresql-devel-7.4.7-3.FC3.1
>
On Wed, 9 Mar 2005 14:28:55 -0300 (ART), marcelo Cortez
<[EMAIL PROTECTED]> wrote:
>
> hello to all
> I have the following problem, when making massive
> update of a table, I received the message
> "segmentation fault" without no other data of the
> error in log.
> Some idea of because it gives
>From your postgresql.conf it look like you're running with a default
config, which is very likely unsuitable for the dataset and/or usage
patterns that you have. Granted that should not cause a seg fault,
but who knows what kind of weirdness is going on behind the scenes.
I didn't see any info f
On Wed, 9 Mar 2005 16:26:53 -0300 (ART), marcelo Cortez
<[EMAIL PROTECTED]> wrote:
> Lonni , folks
>
> >
> > You're doing this from within psql or elsewhere?
> from putty terminal from windows statiom
That doesn't really answer the question. How are you interfacing with
the database? Are you
On Sat, 12 Mar 2005 10:13:34 -0800, bruce <[EMAIL PROTECTED]> wrote:
> hi...
>
> i get a postgres error when i've gone from RH8 to FC3 and am now using
> postgreSQL-7.4.7.
>
> an err msg 'an old version of database format was found. you need to upgrade
> the data format."
>
> searching googl
ld version of the postgres app..
>
> thanks
>
> bruce
>
>
> -----Original Message-
> From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 12, 2005 3:30 PM
> To: [EMAIL PROTECTED]
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERA
On Tue, 15 Mar 2005 16:43:01 +0100, Frederic Massot
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> On the PostgreSQL 6.5 server I use this shell script (see below) for the
> backup all of the database in several files, one file per database.
>
> With version 7.3 of PostgreSQL (and the following) the data a
On Wed, 16 Mar 2005 14:43:09 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> I have a crashed database fileset, and I'm wondering if there is any
> way to recover the data from a specific table. I know which table got
> corrupted, and it's not the table I am trying to recover.
>
> I know this is
On Wed, 16 Mar 2005 15:46:16 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> It's postgresl 8.01 on AMD 64 Suse 9.2. The database didn't dump
> succesfully for several days in a row so the backup is corrupted also.
>
> The controller card crashed and we think caused data corruption. I
> rebooted
On Wed, 16 Mar 2005 16:02:58 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> Fsync was off - we are using XFS and the Microcontroller on the RAID
> card Crashed and took two filesystems offline at about 2 a.m.
Did you run xfs_repair afterwards?
> There were some error messages in the postgres log
On Wed, 16 Mar 2005 16:05:16 -0500, Alex Turner <[EMAIL PROTECTED]> wrote:
> Ok - I found the log messages:
>
> ERROR: duplicate key violates unique constraint "features_pkey"
> STATEMENT: insert into features
> (propid,dtmodified,proptype,groupid,featid,group_desc,feat_desc)
> values (449356005
On Thu, 17 Mar 2005 14:05:35 +0100, Rafael Martinez Guerrero
<[EMAIL PROTECTED]> wrote:
> Hello
>
> We are having problems with pg_dump.
>
> We are trying to dump a 30GB+ database using pg_dump with the --file
> option. In the beginning everything works fine, pg_dump runs and we get
> a dumpfile.
On Thu, 17 Mar 2005 14:48:00 -0500, Kevin Murphy <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> My searches at:
>
> http://archives.postgresql.org/pgsql-general/
>
> haven't been working for the last couple hours; the query times out.
>
> Is this my problem or a real one?
works ok for me.
--
~
On Fri, 18 Mar 2005 08:39:46 +0800 (CST), S Ram <[EMAIL PROTECTED]> wrote:
> Hello,
>
> PostgreSQL is distributed as .RPM files. How do I
> install this in Debian?
apt-get i'd imagine
or build from source.
--
~
L. Friedman
On Fri, 18 Mar 2005 20:28:50 -0300, Fernando Lujan <[EMAIL PROTECTED]> wrote:
> Hi folks,
>
> I wanna know from you, how often must I run vaccum analyze on my db?
>
> Once per day, twice... One per hour and so on...
>
> I didn't find a especific document about this question.
That's because it d
On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg
<[EMAIL PROTECTED]> wrote:
>
> Does anyone know if there is a way in Postgres to emulate Oracle, in other
> words make Postgres think it is an Oracle database? If so, do you have any
> idea what percentage of people are doing this, and how succes
On Tue, 22 Mar 2005 20:38:13 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> Lonni J Friedman wrote:
>
> >On Tue, 22 Mar 2005 17:51:06 -0800, Randy Samberg
> ><[EMAIL PROTECTED]> wrote:
> >
> >
> >>
> >>Does anyone know if there is
On Wed, 23 Mar 2005 12:30:29 -0800, Dann Corbit <[EMAIL PROTECTED]> wrote:
> 1. Excellent stability
Not in my experience.
> 2. Excellent scalability
Well, its an 800lb gorilla, so it starts off with enough momentum.
> 3. Superb toolset
Used sqlplus lately?
> 4. After-market support produc
On Mon, 28 Mar 2005 08:46:09 -0300, Gustavo Franklin Nóbrega - Planae
<[EMAIL PROTECTED]> wrote:
> Hi Janning!
>
> You need to expand your pg_xlog partition. If you use reiserfs, you can
> do this with resize_reiserfs. If you use ext2/ext3 you may try reise2fs.
>
> If you need to repartit
On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne
<[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
>
> >On Wed, 2005-03-30 at 14:28, phil campaigne wrote:
> >
> >
> >>Hi All,
> >>I want to move my development database (7.2.3) to my production server
> >>but the production server database has a d
On Wed, 30 Mar 2005 16:24:54 -0500, phil campaigne
<[EMAIL PROTECTED]> wrote:
> Lonni J Friedman wrote:
>
> >On Wed, 30 Mar 2005 15:58:02 -0500, phil campaigne
> ><[EMAIL PROTECTED]> wrote:
> >
> >
> >>Scott Marlowe wrote:
> >>
>
On Thu, 31 Mar 2005 16:10:04 +0530, Nageshwar Rao
<[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> When I do psql test (database name) it says database "test" does not exists.
>
> But with pgAdminIII utility I get to see the database "test" and able to
> create tables ,insert the data etc.
>
>
On Apr 1, 2005 9:21 AM, David Link <[EMAIL PROTECTED]> wrote:
> Greetings worthymen.
>
> I have a question regarding filesystem disk space usage.
>
> We have a production database containing 5 years of sales data.
> Linux 2.6.5; Postgresq 7.4.7. VACUUM ANALZYE the entire database
> everynight (a
The spam filtering package I use (dspam) had a section in their
release notes recently which stated that disabling OIDs greatly
increased speeds, and so they suggested that people do that on their
tables.
When creating new tables, you can disable OIDs with,
CREATE TABLE foo (...) WITHOUT OIDS;
And
On Sun, 12 Dec 2004 22:16:27 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > The spam filtering package I use (dspam) had a section in their
> > release notes recently which stated that disabling OIDs greatly
> > increa
Greetings,
Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
thanks,
Lonni
--
~
L. Friedman[EMAIL PROTECTED]
LlamaLand http://netllama.linux-sxs.org
-
On Fri, 17 Dec 2004 15:28:30 -0600, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Fri, Dec 17, 2004 at 12:50:42 -0800,
> Lonni J Friedman <[EMAIL PROTECTED]> wrote:
> > Greetings,
> > Are there any alternatives to vacuum (and, i'm aware of autovacuum)?
>
On Wed, 22 Dec 2004 10:38:01 -0600, John Cunningham <[EMAIL PROTECTED]> wrote:
> I'm running Red Hat Enterprise ES with all the most recent updates.
>
> The error - in initdb - was that the system couldn't find
> "ascii_and_mic" libraries. 7.3.6 ran without a hitch.
That's very odd, cause I'm us
On Wed, 22 Dec 2004 12:28:22 -0500, Vivek Khera wrote:
> > "a" == alex <[EMAIL PROTECTED]> writes:
>
> a> We are currently looking at Dell / HP
> a> but the questions is
>
> a> - how many processors (2 or 4)
> a> - do we gain with 4 cpus if we probably never have a few users connected
> a>
Sure, in postgresql.conf uncomment log_min_duration_statement and set
it to whatever value you want to log. This, of course, assumes that
you're already logging for the DB.
On Thu, 23 Dec 2004 07:27:22 -0600, Jason Tesser <[EMAIL PROTECTED]> wrote:
> I am looking for a tool in postgres to monito
ove rthe last 2 weeks. Which ones were slow
> etc.. I dont want to have to read through 2 weeks worth of logs :-)
>
>
> -Original Message-----
> From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
> Sent: Thu 12/23/2004 8:11 AM
> To: Jason Tesser
> Cc: pgsql-general
one to work but I would like to see a tool that is a little
> more robust. maybe even a gui client or something?
>
> -Original Message-
> From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
> Sent: Thu 12/23/2004 8:50 AM
> To: Jason Tesser
> Cc: pgsql-general@postg
ll
> though I liked pqa. Can it be run from windows?
>
>
> -----Original Message-
> From: Lonni J Friedman [mailto:[EMAIL PROTECTED]
> Sent: Thu 12/23/2004 10:39 AM
> To: Jason Tesser
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] monitoring tools
>
I honestly have no idea what that error means, however I'd imagine
that you should be able to dump the DB, and reimport it as a last
resort to fixing this.
On Tue, 28 Dec 2004 18:33:24 -0500, Matthew Terenzio
<[EMAIL PROTECTED]> wrote:
> Trying vacuumdb eventuallydisplays this:
>
> ERROR: catal
Increase logging, and check the log for errors.
On Thu, 30 Dec 2004 23:44:51 -0600, Eric Scott <[EMAIL PROTECTED]> wrote:
> Heya;
> I have PostGreSQL 7.3.4 on Mandrake Linux 9.2. For some reason Webmin,
> when I tell it to change the password of a pgsql user, acts like it's
> working, but still
I've got a server running PostgreSQL-7.2.3 on RHAS-2.1. The version
of Postgresql is *not* my choice, I would have gone with something
much more current, but i digress.
Running 'vacuumdb -a -z -v -f' has started failing:
NOTICE: Index pg_toast_218644531_idx: Pages 1; Tuples 0.
CPU 0.00s
On Tue, 04 Jan 2005 18:30:43 -0500, Tom Lane <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman <[EMAIL PROTECTED]> writes:
> > ERROR: No one parent tuple was found
>
> > Anyone have any suggestions on how to correct this?
>
> Shut down whatever long-running
Which OS are you planning to use? There are pre-built RPMs for Linux,
and pre-compiled binaries for Windows.
On Fri, 7 Jan 2005 06:31:35 -0800, Hong Ji <[EMAIL PROTECTED]> wrote:
> Hi
> I am new to PostgreSQL and interested in using PostgreSQL in our
> application.
> But I have questions regardi
On Wed, 12 Jan 2005 17:08:26 -0300 (ART), Clodoaldo Pinto
<[EMAIL PROTECTED]> wrote:
> There was a power failure and then the postgresql service didn't start on
> system restart:
>
> System restart after power failure:
> Jan 12 16:49:06 s1 syslogd 1.4.1: restart.
> Jan 12 16:49:18 s1 su(pam_unix)[
Greetings,
Is it possible to allow TCP/IP connections from additional hosts (IPs)
without restarting postgresql?
The issue i'm having is that i've got a postgresql-7.4.6 box that has
a DB running on it for a j2ee based application on a separate server.
Now i need to add an additional DB for a dif
Thanks to all who responded. That works perfectly.
On Thu, 13 Jan 2005 19:28:02 +0100, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Lonni J Friedman wrote:
> > Now i need to add an additional DB for a different server, but I
> > can't afford any down time to restart
On Mon, 17 Jan 2005 20:00:46 +0100, Mage <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Gabor Szima asked us to translate the letter below.
>
> "I read that ext3 writeback mode is recommended for PostgreSQL. I made
> some tests.
>
> data=ordereddata=writeback
> ---
On Mon, 17 Jan 2005 16:54:45 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> David Garamond wrote:
>
> > Tzahi Fadida wrote:
> >
> >> I recommend you don't use ext3 for any database:
> >> http://seclists.org/lists/linux-kernel/2005/Jan/0641.html
> >>
> >> apparently its still buggy.
> >
> >
>
On Mon, 17 Jan 2005 23:44:37 -0500, Madison Kelly <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > Michael Fuhr <[EMAIL PROTECTED]> writes:
> >
> >>On Mon, Jan 17, 2005 at 09:03:17PM -0500, Madison Kelly wrote:
> >>
> >>>Is there any way I can log and/or display database calls for a
> >>>specific d
On Tue, 18 Jan 2005 11:12:34 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> At office we have a Win2k LAN to which my freebsd postgresql server box
> is connected via Samba. On this box I have a script, called 'crono', which
> is dealt by /usr/bin/cron every working day's night at 1 am. As
On Tue, 18 Jan 2005 18:23:23 +, Adam Witney <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am setting up the backup strategy for my database.
>
> The database contains around 25 tables containing quite a lot of data that
> does not change very much (and when it does it is changed by me). And aroun
On Tue, 18 Jan 2005 22:31:43 +, Adam Witney <[EMAIL PROTECTED]> wrote:
> On 18/1/05 8:38 pm, "Lonni J Friedman" <[EMAIL PROTECTED]> wrote:
>
> > On Tue, 18 Jan 2005 18:23:23 +, Adam Witney <[EMAIL PROTECTED]> wrote:
> >>
> >>
On Wed, 19 Jan 2005 03:32:05 -0800, J. Greenlees <[EMAIL PROTECTED]> wrote:
> Dick Davies wrote:
> > http://www.postgresql.org
> >
> > looks bloody awful in firefox on debian, until I switch font
> > (on the site) from 'normal' to 'large'.
> >
> > Anyone else seeing that? I'm sure it was fine a cou
http://it.slashdot.org/article.pl?sid=05/01/19/1312224&tid=221&tid=198&tid=185
On Wed, 19 Jan 2005 11:06:56 -0500, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> What does that mean?
>
> Lonni J Friedman
> &l
On Wed, 19 Jan 2005 09:03:31 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
> Martijn van Oosterhout wrote:
>
> >No difference whatsoever from PostgreSQL's point of view. Use whichever
> >distribution is easiest for you to administer. After all, there's no
> >point installing Postgres on a mach
On Wed, 19 Jan 2005 09:19:33 -0800, Bricklen Anderson
<[EMAIL PROTECTED]> wrote:
> Joshua D. Drake wrote:
> > Martijn van Oosterhout wrote:
> >
> >> No difference whatsoever from PostgreSQL's point of view. Use whichever
> >> distribution is easiest for you to administer. After all, there's no
> >>
On Wed, 19 Jan 2005 21:39:23 +0200 (EET), Devrim GUNDUZ
<[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi,
>
> On Wed, 19 Jan 2005, Guy Rouillier wrote:
>
> >> On whitebox & RHEL ext3 is really the only choice. However, FC3
> >> provides all the other major fil
On Sun, 23 Jan 2005 00:13:08 +0200, Jarkko Elfving <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I've started to learn SQL about 6 months ago, and now I'd upgraded
> PostgreSQL 7.4 to new release 8.0. After upgrading I start to read the
> README file (how stupid I was) and there were instructions to how to
On Sun, 23 Jan 2005 08:09:15 +0200, Jarkko Elfving <[EMAIL PROTECTED]> wrote:
> Hi again...
>
> I tried to solve my PostgreSQL cluster problem like Michael Fuhr and
> Lonni Friedman helps me, but I didn't get it work. So I figured out that
> if I do an fresh installation and removed the PostgreSQL
On Sun, 23 Jan 2005 09:46:29 +0200, Jarkko Elfving <[EMAIL PROTECTED]> wrote:
> On Sun, 2005-01-23 at 02:15 -0500, Tom Lane wrote:
> > Uh, /var/lib/pgsql should have been created for you by RPM installation.
> > I'm starting to think you have a corrupted postgresql-server RPM.
> >
> > Also, in your
On Sun, 23 Jan 2005 12:57:18 -0300, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> On Sun, Jan 23, 2005 at 07:46:26AM -0800, Lonni J Friedman wrote:
> > On Sun, 23 Jan 2005 09:46:29 +0200, Jarkko Elfving <[EMAIL PROTECTED]>
> > wrote:
>
> > I'm thinking y
On Mon, 24 Jan 2005 10:25:09 -0500, Rick Schumeyer <[EMAIL PROTECTED]> wrote:
>
>
>
> I hope this is a valid question for this list.
>
>
>
> I want to install PG 8.0 on a RHEL system.
>
> I have been told our security policy says
>
> that only packages provided by red hat can be inst
I'd doubt that the RHES3 RPMs work on RHAS-2.1. The RH9 RPMs might
work ok on RHAS-2.1, but i've not tested them.
On Tue, 25 Jan 2005 10:57:13 -0500 (EST), Fabio Esposito
<[EMAIL PROTECTED]> wrote:
>
> Hello
>
> I wanted to ask if anyone knows if 8.0 is available as a RH AS package?
> Or perha
Setting the number of something higher than 250ms ?
On Wed, 26 Jan 2005 02:39:21 -0800, Eric Brown <[EMAIL PROTECTED]> wrote:
> I set this to 250 and the statements that take longer than this are
> logged... but my driver is creating all kinds of cursors, so it isn't
> logging anything useful. Ye
Is the server running on host "localhost" and accepting TCP/IP
connections on port 5432? What does your pg_hba.conf look like? Did
you enable TCP/IP connections in postgresql.conf ?
On Wed, 26 Jan 2005 10:04:35 -0500, Danny Lu <[EMAIL PROTECTED]> wrote:
> Hello all,
>I am running Postgresql
Is there any way to increase sort_mem without having to perform a full
restart of the DB? Will just doing a 'kill -HUP $PID" work as long as
i've made the change in postgresql.conf first?
As a side question, are the options that will take effect with a kill
-HUP documented somewhere?
thanks!
--
OK, but does that actually work to change sort_mem for all future connections?
On Thu, 27 Jan 2005 19:25:51 -0600, Jonel Rienton <[EMAIL PROTECTED]> wrote:
> I usually use pg_ctl reload instead of kill
>
> On Thu, 27 Jan 2005 14:57:22 -0800, Lonni J Friedman wrote
> >
101 - 200 of 218 matches
Mail list logo
