On Tue, May 18, 2010 at 12:11 PM, akp geek wrote:
> pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres
> testDB_20100414.txt-f outputifile
>
>
> I got the following error "pg_restore: options -d/--dbname and -f/--file
> cannot be used together"
>
I think you would either ca
On Tue, May 18, 2010 at 4:45 AM, Malm Paul wrote:
> I can add that I would like to do this in my java application.
> E.i. just create an empty table in database1 which has the same column
> names and types as a table stored in database2.
>
> I tried this for a start:
> stmnt = dbConnection.prepa
On Thu, May 13, 2010 at 6:23 PM, Scott Marlowe wrote:
> On Thu, May 13, 2010 at 4:05 PM, Joao Ferreira
> wrote:
> >
> > Hello all,
> >
> > I have a hard situation in hands. my autovacuum does not seem to be able
> > to get his job done;
> >
> > database is under active INSERTs/UPDATEs;
> > CPU is
your testing make sure that you leave that 'warning' or 'notice' for
production, leaving those logs at DEBUG will also chew up I/O and get in the
way of things like autovacuum.
What version of Postgres are you using? The visibility map in 8.4 should
lower the amount of I/O that
On Thu, May 13, 2010 at 8:16 PM, Scott Marlowe wrote:
> On Thu, May 13, 2010 at 9:50 AM, Wang, Mary Y
> wrote:
> > Hi,
> >
> > I'm running on Postgres 8.3.8. My system admin is ready to set up a cron
> job for a daily database backup.
> > By reading the documentation over here:
> http://www.post
On Fri, May 14, 2010 at 4:43 AM, Ivan Voras wrote:
> On 14 May 2010 09:08, Leonardo F wrote:
> >> Personally I would lean toward making
> >> the bulk of security within the
> >> application so to simplify everything - the
> >> database would do what it
> >> does best - store and manipulate data
On Thu, May 6, 2010 at 11:30 AM, Thom Brown wrote:
> On 6 May 2010 16:15, Andy Colson wrote:
>
>> On 5/6/2010 2:57 AM, Jaume Calm wrote:
>>
>>> Hi! I was searching for a command like pg_dumpall but with the
>>> difference that I don’t want a single file for all databases, i would
>>> like to hav
On Thu, May 6, 2010 at 3:57 AM, Jaume Calm wrote:
> Hi! I was searching for a command like pg_dumpall but with the difference
> that I don’t want a single file for all databases, i would like to have a
> file for each one.
>
>
>
> I couldn’t fins such command, so the only option I see is to writ
45.248", user "postgres",
> database "arc"
>
> pg_hba.conf contains the line:
> hostall all209.159.145.248 255.255.255.255
> trust
>
>
Hmm, just for giggles, does it work using CIDR syntax:
host all all209.
ngage$ sudo su postgres
> bash-3.2$ ./createlang -l
> Password:
> Procedural Languages
> Name | Trusted?
> --+--
>
> bash-3.2$
>
> On Apr 27, 2010, at 1:47 AM, Scott Mead wrote:
>
> On Mon, Apr 26, 2010 at 3:36 AM, Jorge Arevalo
> wrote:
>
>> On Sun, Apr
On Mon, Apr 26, 2010 at 3:36 AM, Jorge Arevalo wrote:
> On Sun, Apr 25, 2010 at 11:08 AM, John Gage
> wrote:
> > If I open a bash terminal and type createlang -l, I get:
> >
> > JohnGage:~ johngage$ createlang -l
> > -bash: createlang: command not found
> > JohnGage:~ johngage$ psql
> > -bash: ps
On Wed, Apr 21, 2010 at 6:07 PM, John Gage wrote:
> I enter the identical command:
>
> select * from mesh_descriptors;
>
> using the psql command line and it works perfectly.
>
> The same command in a file produces an immediate syntax error:
>
> EFNWeb=# \i ./CopySql.sql
> psql:./CopySql.sql:1: E
On Fri, Apr 16, 2010 at 10:36 AM, Tom Lane wrote:
> Scott Mead writes:
> > Huh? This I find hard to believe. Whenever I've had problems with
> readline
> > it was actually libtermcap that was giving me a headache. Are you sure
> that
> > there's nothing
On Thu, Apr 15, 2010 at 10:22 PM, zhong ming wu wrote:
> Dear List
>
> I need to build a postgres on a linux machine that I don't have root
> access.
>
> I built readline from source and installed it with prefix of /home/me/local
>
> readline library are in /home/me/local/lib and headers files ar
On Wed, Apr 14, 2010 at 11:04 PM, gvim wrote:
> I'm running PostgreSQL 8.4.3 on OS X Snow Leopard via MacPorts and I'm
> getting strange inconsistent errors such as:
>
> dbuser-# select * from log_form;
> ERROR: syntax error at or near "select"
> LINE 2: select * from log_form;
>^
>
> Th
On Wed, Apr 14, 2010 at 1:43 PM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to Andre Lopes :
> > Thanks a lot, it works!
> >
> > I'am using Postgres Plus Advanced Server 8.3R2 in development.In
> production I
> > user PostreSQL 8.3.9.
>
> Yeah, AFAIK is the "Postgres P
On Wed, Apr 14, 2010 at 11:03 AM, Scott Mead
wrote:
>
> On Wed, Apr 14, 2010 at 10:56 AM, akp geek wrote:
>
>> Dear all -
>>
>> Can you please help me with this? Is there a way to restore
>> multiples ( more than one table ) using a single command from
On Wed, Apr 14, 2010 at 10:56 AM, akp geek wrote:
> Dear all -
>
> Can you please help me with this? Is there a way to restore
> multiples ( more than one table ) using a single command from a whole
> database dump that was created using pg_dump
>
>
Depends on exactly how you took the pg_
On Thu, Apr 1, 2010 at 2:41 PM, Brad Nicholson wrote:
> Hi,
>
> Is anyone using Lifekeeper for Linux availability with Postgres?
>
> If so, what are your thoughts on it? Work as advertised? Any dangerous
> gotchas?
>
> I have a lot of customers using it. The latest version fixes the issue
that
On Fri, Apr 9, 2010 at 1:08 PM, arya6000 wrote:
>
> Hello
>
> I have spent hours trying to make this work, but its still not working. I
> tried to connect using my Java program and using pgAdmin III. Postgre is
> hosted on a Debian 5 64 bit vps and here are the changes I made.
>
> I edited postgr
2010/4/6 Björn Lindqvist
> Den 5 april 2010 11.57 skrev Magnus Hagander :
> >> Note how the planner estimates that there are 766 rows in the table
> >> that matches the word 'tagtext'. In reality 43374 does. I've tried to
> >> get postgres to refresh the statistics by running with
> >> enable_sta
2010/3/25
> >> Oracle uses a completely different implementation of MVCC architecture.
> >> It
> >> overwrites the data and then uses rollback segments to provide 'previous
> >> versions' to running transactions etc.
> >>
> >> PostgreSQL does not overwrite the data - it just creates a copy of
On Thu, Mar 25, 2010 at 1:26 AM, John R Pierce wrote:
> Yogi Yang 007 wrote:
>
>> Hello,
>>
>> I am new to pgSQL. I would like to know if there is a way to do the
>> following using pure SQL:
>> 1. Retrieve list of all Tables in a database
>> 2. Retrieve list of all Functions, Triggers, Sequences
On Tue, Mar 23, 2010 at 4:23 AM, Sergio Ramazzina wrote:
> Hi everybody,
>
> I'm new to postgresql and I need some help to understand the behaviour of
> before insert triggers in postgresql. I'm trying the sample
> documented in the user manual about implementing table partitions (
> http://www.po
On Sat, Mar 20, 2010 at 5:24 PM, Adam Seering wrote:
> Hi,
>I'm trying to set up an internal general-purpose PostgreSQL server
> installation. I want most users with login access to the server to be able
> to create databases, but only with names that follow a specified naming
> conventi
reporting, how are you inserting the data now? Are you
using individual inserts, or are you loading in batches. Typically, if you
can buffer some of the inserts into a group on the application side and then
load them you'll be better off then just doing straight inserts for every
'event
xtuple ERP does and the latest version of GNUCash can use postgres as a
backend too.
--Scott M
On Thu, Mar 18, 2010 at 1:11 PM, Garry Saddington <
ga...@schoolteachers.co.uk> wrote:
> Does anyone know of a web based accounting(finance) package that uses
> Postgresql as a backend?
> Thanks Ga
On Tue, Mar 9, 2010 at 9:56 AM, Scott Marlowe wrote:
> On Tue, Mar 9, 2010 at 6:47 AM, Scot Kreienkamp
> wrote:
> > Wish I could Tom. I need a non-production, read-write copy of the
> > database that is updated every 1-2 hours from production. I don't set
> > this requirement, the business does.
On Tue, Mar 9, 2010 at 10:01 AM, Scott Mead wrote:
>
> On Tue, Mar 9, 2010 at 9:56 AM, Scott Marlowe wrote:
>
>> On Tue, Mar 9, 2010 at 6:47 AM, Scot Kreienkamp
>> wrote:
>> > Wish I could Tom. I need a non-production, read-write copy of the
>> > databa
On Mon, Mar 8, 2010 at 5:13 PM, Scot Kreienkamp wrote:
> Hi everyone,
>
> I have a database that is constantly getting reloaded several times per
> day from production backups and is used for reporting purposes. The
> problem I'm having with it is that the database seems to be much slower
> than
On Mon, Mar 8, 2010 at 4:58 PM, Sam Carleton wrote:
> On Mon, Mar 8, 2010 at 4:07 PM, John R Pierce wrote:
>
>>
>> and what happens if someone copies your directory without shutting down
>> the instance?
>>
>
> Well, that is an issue right now, the current SQLite DB is locked by the
> app and can
Those are the free space map / visibility map files. There is going to be
one of each for every relation.
No worries :-) They are supposed to be there:
http://wiki.postgresql.org/wiki/Segment_Visibility_Map
Don't clean them up, doing so could be disastrous. Actually, if I were
you, I wo
On Sat, Feb 6, 2010 at 2:19 PM, Michael Kohout wrote:
> Hi All;
>
> I've got a development box that I use for a bunch of other purposes(mostly
> music), and I was wondering if there was a way to configure launchd to only
> start up postgres when it's needed. SSH does the same thing so I've tried
On Thu, Feb 4, 2010 at 1:40 PM, Krzysztof Walkiewicz wrote:
> Hello!
>
> I created database "krzysztof" for practice postgresql. After few days i
> deleted that database and i created the next one "cwiczebna". Now when I
> type "psql" i get strange info, something like: "CRITICAL: base "krzyszto
Mary,
EnterpriseDB (my employer) runs both public and custom training classes:
http://www.enterprisedb.com/tservices/training/schedule.do
If you're interested, let me know and I'll get you talking to someone asap.
--Scott Mead
scott.m...@enterprisedb.com
On Thu, Feb 4, 2010 at 12:0
On Thu, Jan 14, 2010 at 11:10 AM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to a.bhattacha...@sungard.com :
> > CREATE TABLESPACE bank_master_tbsp OWNER bank LOCATION ?$drive/data/bank/
> > master_tbsp';
> >
> > CREATE TABLESPACE bank_static_tbsp OWNER bank LOCATION ?
On Thu, Jan 14, 2010 at 7:19 AM, Vincenzo Romano <
vincenzo.rom...@notorand.it> wrote:
> 2010/1/14 Adrian Klaver :
> > On Wednesday 13 January 2010 2:17:51 pm Scott Mead wrote:
> >> On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano <
> >>
> >> vincenz
On Wed, Jan 13, 2010 at 11:00 PM, Vincenzo Romano <
vincenzo.rom...@notorand.it> wrote:
> It is not the check or the select.
> It is the way the substitution has been implemented. It looks like the code
> replaces the variable name and not the value.
> Which is different from what is written at pa
On Tue, Jan 12, 2010 at 7:17 AM, Greg Smith wrote:
> AI Rumman wrote:
>
>> I used the followings:
>> create tablespace mytabspc location '/var/lib/pgsql/data/pg_tblspc';
>> create database mydb with tablespace=mytabspc;
>> drop database mydb;
>> drop tablespace mytabspc;
>> ERROR: tablspace '
On Tue, Dec 15, 2009 at 11:34 AM, NetLevel Admins wrote:
> Hello,
>
> I created database dump on server version 8.3.7 and trying to import it to
> server v. 8.1.18, but i see errors.
>
>
>>
> What could be a problem and is there a solution?
>
Looks like your 8.1.18 doesn't have any users in it.
On Tue, Dec 15, 2009 at 4:51 AM, wrote:
> Hi All,
>
>
>
> I have my application UI in Java and which is communicating with Postgresql
> database.
>
> However whenever my application is running I could see there are too many
> postgres.exe are created even though the application is not doing anyt
On Mon, Dec 7, 2009 at 10:35 AM, AlannY wrote:
> Hi there.
>
> I'm using PostgreSQL as my main database engine. Everything works.
>
> I have one server for PostgreSQL, and space on it are lowing down.
>
> I want to buy a new server and somehow connect it with first one, that
> PostgreSQL will use
On Fri, Nov 13, 2009 at 12:15 PM, Joao Ferreira gmail <
joao.miguel.c.ferre...@gmail.com> wrote:
> Hello all,
>
> How can I safelly erase (with rm command in Linux) files or dirs
> concerning a specific database ?
>
Using 'rm', you can't -- not safely anyways.
>
> assuming I whish to elimiant
On Wed, Nov 11, 2009 at 12:51 PM, akp geek wrote:
> Hi All -
> I have read the document got a reasonable
> understanding of the WAL process. I have some confusion regarding the
> process.
>
> 1. I have set up the archiving process. Now the archive file are going
> to a different
On Tue, Nov 10, 2009 at 9:52 AM, Greg Stark wrote:
>
> It's always worth having the dump, even if you also implement PITR.
> The dump allows you to restore just specific tables or to restore onto
> a different type of system. The PITR backup is a physical
> byte-for-byte copy which only works if
On Fri, Oct 16, 2009 at 2:38 PM, Scot Kreienkamp wrote:
> Hey everyone,
>
>
>
> I apologize in advance for going slightly off topic, but I have never setup
> a centralized authentication scheme under Linux. My question is, what do
> most people do for centralized command line, X, and PG authenti
On Thu, Oct 15, 2009 at 12:07 PM, Brian Modra wrote:
> 2009/10/15 Bob Pawley :
> > Hi
> >
> > While looking at an error message for iexplore.exe, I noticed, on Task
> > Manager, that there are 5 or more instances of postgres.exe running. Each
> > instance is consuming between 7 to 10 megs of reso
2009/10/6 Krzysztof Barlik
> Hi,
>
> is it possible to force pg_dumpall to ask for
> password only once (connecting as superuser 'postgres') ?
>
> Entering it for every database is a bit annoying.
>
Kind of, you'll either use an environment variable:
http://www.postgresql.org/docs/8.4/interact
On Tue, Oct 6, 2009 at 3:09 PM, Sachin Srivastava <
sachin.srivast...@enterprisedb.com> wrote:
> On 10/06/2009 11:41 PM, Raymond O'Donnell wrote:
>
>> On 06/10/2009 19:00, Sachin Srivastava wrote:
>>
>>
>>
>>> fixing permissions on existing directory d:/base/netscope/pg/data ... ok
>>> * creating
On Fri, Aug 7, 2009 at 9:52 AM, Adrian Klaver wrote:
> On Friday 07 August 2009 6:42:07 am John wrote:
> > Hi,
> > There is an accounting system called postbooks that uses Postgres for the
> > backend. I just downloaded the program yesterday. What is interesting
> is
> > within one database the
On Thu, Jul 30, 2009 at 11:02 AM, Vick Khera wrote:
> On Thu, Jul 30, 2009 at 7:37 AM, Phoenix Kiula
> wrote:
> > We installed 8.3.7 on a new server. Some of the config changes such as
> > tracker_acvitity etc are nice.
> >
> > But big problem. When I start SVN on this machine (which we need!) I
On Thu, Jul 30, 2009 at 9:36 AM, Phoenix Kiula wrote:
> On Thu, Jul 30, 2009 at 8:31 PM, Scott Mead
> wrote:
>
> ...snip...
>
> > It may make more sense to setup a dedicated PITR slave in your office,
> and
> > refresh it every now and then.
> >
&g
On Thu, Jul 30, 2009 at 7:47 AM, Phoenix Kiula wrote:
> I use a Mac OSX at work. And finally have a running PG install.
>
> So I'm thinking: can I use some mechanism to have my local PG server
> (in our premises) as a slave mirror of the main live website server
> (at our data center).
>
>
> Woul
On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane wrote:
> Sorry, yes the error, Doh!.
>
> Standard Server doesn't Listen (sounds like my ex :))
>
> Here it is in full.
>
> Server doesn't listen
>
> could not connect to server; Connection timed out (0x274C/10060) Is the
> server running on host 192
On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane wrote:
> Sorry, yes the error, Doh!.
>
> Standard Server doesn't Listen (sounds like my ex :))
>
> Here it is in full.
>
> Server doesn't listen
>
> could not connect to server; Connection timed out (0x274C/10060) Is the
> server running on host 192
Re-REM (called commenting for us non-windows geeks :-) the line
Look in your data directory, the file exists and is used automatically, you
don't need to point the postgresql.conf file to it explicitly.
Look at:
http://www.postgresql.org/docs/8.3/interactive/client-authentication.html
For deta
On Wed, Jul 29, 2009 at 3:27 AM, Peter Eisentraut wrote:
> On Tuesday 28 July 2009 02:53:19 Christophe Pettus wrote:
> > I'm moving from a long time in BSD-land to using Linux. I've always
> > been in the habit of building PostgreSQL from the source tarballs. On
> > Linux, is there an advantage
On Tue, Jul 28, 2009 at 12:08 PM, Graeme Gemmill wrote:
> If I download the source of postgreSQL8.4.0, will the -devel header stuff
> be included? I need it for
> compilation of C code and other stuff.
Yes, all the includes are there. Depending on what you're doing, you may
need to build it fir
On Mon, Jul 27, 2009 at 4:45 PM, Tory M Blue wrote:
>
>
> And those that have multiple TB's of data, weee another dump and
> restore upgrade (pt!)
pg_migrator doesn't need to dump -> restore, it can do an in-place upgrade
of the datafiles for you.
http://archives.postgresql.org/pgsql
On Fri, Jul 24, 2009 at 6:31 AM, Jazz Johal wrote:
> Hi
>
> Is it possible to setup replication from EDB to Postgres?
>
You can with slony. I recommend you contact supp...@enterprisedb.com for
details.
--Scott
Hey all,
I'm looking at windows, and a couple of quick google's didn't give me
anything,
If I set my log_min_duration_statement < 16 ms, I get one of 2 values
for my pgbench runs (pretty quick statements). 0, or 16 ms (sometimes
15.999). If I benchmark some other way (via my app) things l
On Tue, Jul 14, 2009 at 1:16 AM, V S P wrote:
> Hello
>
> I am researching how to store the data for easy 'user-driven'
> reporting (where I do not need to develop application for
> every user request).
>
> The data will typically be number ranges and text strings with
> unique Id for each row
>
On Mon, Jul 13, 2009 at 3:29 PM, Sam Mason wrote:
> On Mon, Jul 13, 2009 at 06:57:43PM +, Nelson Correia wrote:
> > Running pg_dump from another machine needs much space on the DB
> > host? Or it just outputs the data as it goes?
>
> pg_dump should use very little space on the server, it just
On Mon, Jul 13, 2009 at 2:05 AM, Philippe Lang wrote:
> Hi,
>
> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
> there a chance we can see one day "START WITH... CONNECT BY" in
> Postgresql, or is that something 100% oracle-specific?
There is a commercial / proprietary
On Mon, Jul 13, 2009 at 2:05 AM, Philippe Lang wrote:
> Hi,
>
> Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is
> there a chance we can see one day "START WITH... CONNECT BY" in
> Postgresql, or is that something 100% oracle-specific?
There is a commercial / proprietary
On Tue, Jul 7, 2009 at 1:26 PM, Scott Mead wrote:
>
>
>
> You may have some luck by viewing a similar thread on another mailing list:
>
> http://www.theserverside.net/discussions/thread.tss?thread_id=54755
>
That being said, I would highly recommend using:
http://
On Tue, Jul 7, 2009 at 11:48 AM, Rstat wrote:
>
>
> Hi, Im building a database for my company. We are a rather small size book
> company with a lot of references and still growing.
>
> We have a Mysql database here and are trying to find some good tools to use
> it at its best. Basically we are j
On Wed, Jul 1, 2009 at 12:21 PM, johnf wrote:
> On Monday 29 June 2009 09:26:24 am Craig Ringer wrote:
> > Try connecting to the database with psql and running
> > "select * from pg_stat_activity"
> > while the web app is running. You should see only "IDLE" or working
> > connections, never idl
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes wrote:
> Sorry if posting twice, wasn’t part of general when sent and didn’t see
> it received by group.
>
> I started an online backup of postgres, tar’d my data folder, copy to usb
> drive in production
> and restored it into my RC environment. H
On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes wrote:
> Sorry if posting twice, wasn’t part of general when sent and didn’t see
> it received by group.
>
> I started an online backup of postgres, tar’d my data folder, copy to usb
> drive in production
> and restored it into my RC environment. H
On Mon, Jun 29, 2009 at 1:01 PM, Jeff Davis wrote:
>
>
> CREATE USER read_only_user
> GRANT (SELECT ON TABLE, USAGE ON SCHEMA) FROM admin_user;
>
> "read_only_user" would automatically have SELECT privileges on any table
> that admin_user has SELECT privileges on, and automatically have USAGE
>
On Mon, Jun 29, 2009 at 10:49 AM, Cédric Villemain <
cedric.villem...@dalibo.com> wrote:
> Le samedi 27 juin 2009, Merlin Moncure a écrit :
>
> >
> > Interestingly, the one platform that tends not to suffer from this is
> > windows so I'm guessing this is a readline problem. Has anybody else
> >
On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris wrote:
> On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead
> wrote:
>
>>
>>It is important to note (as many people have already pointed out) that
>> both EnterpriseDB and Oracle's wrap functionality is declared as a 1
On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris wrote:
> On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead
> wrote:
>
>>
>>It is important to note (as many people have already pointed out) that
>> both EnterpriseDB and Oracle's wrap functionality is declared as a 1
On Fri, Jun 26, 2009 at 3:37 PM, wrote:
>
>
> I completely agree w/ HArald. Its not something we'd want to see in an open
> source product. That said, I saw yesterday that the latest version of
> EnterpriseDB has this feature. So if you want to protect your own IP, then
> you've got to purchase
2009/6/23 David Fetter
> On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote:
> > Hello,
> >
> > Please can you assist on following questions.
>
> This is an issue for pgsql-general, where I'm redirecting this.
> >
> > * do you any tool to check postgreSQL database integrity check?
>
>
On Tue, Jun 23, 2009 at 10:07 PM, Craig Ringer
wrote:
> Thomas Kellerer wrote:
> > Mike Christensen wrote on 23.06.2009 19:37:
> >> Does anyone actually have that (any node can go down and the others
> still
> >> replicate amongst themselves?)
> >
> > I think this is what Oracle promises with thei
2009/6/23 Radcon Entec
> Greetings!
>
> At the current moment, our customer's computer has 22 instances of
> postgres.exe running. When a colleague checked a few minutes ago, there
> were 29. Our contract specifies that we cannot consume more than 40% of the
> computer's memory, and we're over
On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce wrote:
> Whit Armstrong wrote:
>
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>>
>
You could also login to the database and run:
select count(1) from pg_stat_activity;
--Scott
On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce wrote:
> Whit Armstrong wrote:
>
>> anyone know a way to get nagios to monitor the number of postgres
>> connections?
>>
>>
>
You could also login to the database and run:
select count(1) from pg_stat_activity;
--Scott
On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington <
ga...@schoolteachers.co.uk> wrote:
> I ahve the following python file that I am running as an external method in
> Zope.
>
> def backup():
> import os
> os.popen("c:/scholarpack/postgres/bin/pg_dump scholarpack >
> c:/scholarpack/ancillary/
On Mon, Jun 8, 2009 at 1:30 PM, Madison Kelly wrote:
>
>
> That works like a charm, thank you!
No problem :)
>
>
> Next question though;
>
> How can I get it to save my custom prompt across sessions/server restarts?
> It there something equivalent to '.bash_profile'?
>
~/.psqlrc
--Scott
On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly wrote:
> Hi all,
>
> I work on a development and production server, and I am always
> double-checking myself to make sure I am doing something on the right
> server.
>
> Is there a way, like in terminal shells, to change the PgSQL shell's
> prompt
On Wed, May 27, 2009 at 1:57 PM, Alan McKay wrote:
> Hey folks,
>
> I have done some googling and found a few things on the matter. But
> am looking for some suggestions from the experts out there.
>
> Got any good pointers for reading material to help me get up to speed
> on PostgreSQL clusteri
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
te University
> 330.941.2483 (Office)
> jtrim...@cc.ysu.edu
> http://www.maag.ysu.edu
> http://digital.maag.ysu.edu
>
>
>
> On May 19, 2009, at 7:28 PM, Scott Mead wrote:
>
>
> On Tue, May 19, 2009 at 7:23 PM, Jeffrey Trimble wrote:
>
>> Hi.. thanks.
>> Here
On Tue, May 19, 2009 at 7:23 PM, Jeffrey Trimble wrote:
> Hi.. thanks.
> Here's a printout from my find command:
>
> /usr/local/include/readline
> /usr/local/include/readline/readline.h
>
>
> And the plot thickens. Here is where it errors out and then loops endlessly
> until it quits:
> (There are
On Tue, May 19, 2009 at 7:08 PM, Jeffrey Trimble wrote:
> Thanks, but that didn't work. Here's the complete error result from that:
> checking for -lreadline... no
> checking for -ledit... no
> configure: error: readline library not found
> If you have readline already installed, see config.log f
On Tue, May 19, 2009 at 6:34 PM, Jeffrey Trimble wrote:
> I'm attempting to install 8.2x postgresql, and configure fails to find the
> realine libraries.
> Here's my configure:
>
> ./configure --with-includes=/usr/local/include:/usr/local/include/readline
> --with-libraries=/usr/local/lib
>
Be
On Fri, May 15, 2009 at 1:11 PM, Raphael Bauduin wrote:
> Hi,
>
> Are there any tool/libs to easily and rapidly generate web-based entry
> forms for tables in a postgresql database?
>
I used this once for a quick project:
http://www.sqlmaestro.com/products/postgresql/phpgenerator/
--Scott
On Thu, May 7, 2009 at 2:56 PM, Scott Marlowe wrote:
> On Thu, May 7, 2009 at 4:54 AM, Glyn Astill
> wrote:
> >
> >> From: S Arvind
> >> Subject: [GENERAL] Upgrading from postgres 8.1 to 8.3
> >> To: pgsql-general@postgresql.org
> >> Date: Thursday, 7 May, 2009, 11:42 AM
> >> Our 600GB data was
On Thu, May 7, 2009 at 11:29 AM, Conrad Lender wrote:
>
> I'm beginning to feel incredibly dense now, but this actually brought my
> original problem back. When I do specify log_filename and log_directory,
> and restart Postgres, the test you suggested ('select 1/0;') shows up as
> an error in th
On Wed, Apr 22, 2009 at 9:16 AM, S Arvind wrote:
> I set log_min_duration_statement to 1 and restart the postgres. But
> when
> i check the tail to log i am getting all queries. please tell is it bug ?
> i have log_statement = all . is there any relation between this and
> min_duaration?
I
On Fri, Apr 17, 2009 at 10:47 AM, Mary Sipple wrote:
> We have a script wrapper for psql which reads a configuration file and
> constructs a psql command to connect to the configured instance of postgres.
> We would like to include a search_path setting in the configuraration file
> and have the
On Fri, Apr 17, 2009 at 10:47 AM, Mary Sipple wrote:
> We have a script wrapper for psql which reads a configuration file and
> constructs a psql command to connect to the configured instance of postgres.
> We would like to include a search_path setting in the configuraration file
> and have the
On Tue, Apr 14, 2009 at 8:28 AM, sandiphw wrote:
>
> I have tried all possible variation of syntax I can imagine, like
>
> host all all 202.18.10.0/24
> ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
> host all all 202.18.10.0/24 ldap
> ldap://202.18.10.1:389/dc=abc,dc=net;;ou=people
> h
On Wed, Apr 8, 2009 at 12:05 PM, Jennifer Trey wrote:
> max_connections = 150 # A comprimise :)
>
> Scott, you mentioned :
>
> You can also use the pg_stat_all_indexes table to look at index scans
> vs. tuples being read, this can sometimes hint at index 'bloat'. I
> would also recommend pg_stattu
On Wed, Apr 8, 2009 at 10:23 AM, Bill Moran wrote:
> In response to Jennifer Trey :
>
>
> > *maintenance_work_mem = 16384 *
If your vacuums and / or create index are taking ages, considering a
higher value here may be useful. I would need to know more about the
database before suggesting tho
On Wed, Apr 8, 2009 at 7:50 AM, Jennifer Trey wrote:
>
> The service did not report an error.
>
> More help is available by typing NET HELPMSG 3534
>
> Not sure what is going on. Server refuses to start it seems. Please help me
> debug this problem :)
>
My first guess as to why this is happenin
If you are using the EnterpriseDB release, and paying for support, you can
always take this to them.
Sent from my mobile device
-Original Message-
From: Patrick Desjardins
Date: Wed, 1 Apr 2009 11:53:59
To: Emanuel Calvo Franco
Cc:
Subject: [GENERAL] Re: [GENERAL] ERROR: XX001: coul
101 - 200 of 201 matches
Mail list logo
