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
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 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 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
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 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
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 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 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 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 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
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 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
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 Mon, Apr 18, 2011 at 4:39 PM, Merlin Moncure wrote:
> ...is an amazing tool!
>
>
I've seen it, but catalog hacks always make me nervous. Anybody else have
good / bad experience to share?
--scott
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make
On Tue, Apr 19, 2011 at 9:48 AM, Jens Wilke wrote:
> On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote:
>
> > > IIRC "vacuum full" mode rewrites the indexes as well.
> >
> > Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the
> table.
>
> Don't be confused with the "
On Thu, May 5, 2011 at 1:40 PM, Merlin Moncure wrote:
> On Thu, May 5, 2011 at 12:13 PM, Sam Nelson
> wrote:
> > Hi List,
> > We have a customer who is trying to migrate a few PostgresPlus instances
> to
> > GridSQL clusters. They have a process that pulls data from another
> server
> > using d
2011/8/24 Ondrej Ivanič
> Hi,
>
> On 25 August 2011 11:17, Toby Corkindale
> wrote:
> > Do I need to make sure I re-create every index on every child table I
> > create?
> > That would be.. annoying, at best.
>
> Yes, it is little bit annoying but I like it. You don't need any index
> on parent
On Tue, Aug 30, 2011 at 1:20 PM, Scott Ribe wrote:
> On Aug 30, 2011, at 11:14 AM, Rich Shepard wrote:
>
> > The permissions on that directory are 755 and it's owned by me. Since I
> > have no problems writing other files to that directory I must have the
> > command syntax incorrect but I don't s
On Wed, Sep 14, 2011 at 5:31 AM, Adarsh Sharma wrote:
> Any update on below issue.
>
>
Someone already responded to you with the answer, don't top-post.
>
> Thanks
>
>
>
> Adarsh Sharma wrote:
>
>> Dear all,
>>
>> Today I need some part ( subset ) of some tables to another database to a
>> remot
On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö wrote:
>
> > Can anyone advice about a tool to visualize a database schema? Ideally,
> I would like something that takes the SQL definition of a schema or database
> > (essentially the output of pg_dump) and produces a graphical
> representation of t
Hey Ian,
On Thu, Oct 11, 2012 at 10:52 AM, Ian Harding wrote:
> I know this is the wrong place, but I tried creating an account on
> their site to contact them and it does not work.
>
>
I'll take a look at that right away, sorry it happened!
> The 9.0.10 package throws an error when I try to
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 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 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 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
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
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.
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
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 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 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
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 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
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 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 12:15 PM, Thom Brown wrote:
> On 18 May 2010 17:11, 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
> > cann
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 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 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 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 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 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, 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 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 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 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 ?
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, 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
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
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 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
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 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 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.
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
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
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
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 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
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
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
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
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 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 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 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: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 Thu, Oct 20, 2011 at 1:12 PM, Ian Harding wrote:
> If someone happened to accidentally end up with a lot of files that
> were NOT part of their database in the data/base/X directory, how
> could they go about getting a reliable list of files they could safely
> delete? The files were ther
On Thu, Oct 27, 2011 at 2:39 PM, Brian Fehrle wrote:
> Hi all, need some help/clues on tracking down a performance issue.
>
> PostgreSQL version: 8.3.11
>
> I've got a system that has 32 cores and 128 gigs of ram. We have connection
> pooling set up, with about 100 - 200 persistent connections ope
tion. DO NOT under ANY circumstances try to run both primary and
secondary on the same data directory simultaneously. You will corrupt your
entire database. The only way to run postgres with shared disk clustering
is in Active/Passive mode.
--
Scott Mead
OpenSCG http://www.openscg.com
> Tha
bname=XYZ host= user=cls password=1) failed - could
> > not translate host name
>
If you want to connect to an instance on the local machine with unix
sockets, don't include the host=
--
Scott Mead
OpenSCG http://www.openscg.com
> The host is missing from the above.
On Sat, Nov 12, 2011 at 1:02 PM, Jerry Levan wrote:
> I think I have somehow botched my installation of 9.1.1 on Mac OSX 10.7.2
>
> I have a mac running 9.1.1.
>
> I then built dblink from the contrib directory and I did not
> see an install option in the make file.
>
The Makefile should be inc
On Thu, Nov 17, 2011 at 11:46 AM, Tomas Vondra wrote:
> On 17 Listopad 2011, 17:32, hubert depesz lubaczewski wrote:
> > On Thu, Nov 17, 2011 at 09:29:11AM -0700, J.V. wrote:
> >> I am in need of a tool or method to see each/every SQL query that
> >> hits the PostgreSQL database. By query I mean
On Thu, Nov 17, 2011 at 4:32 PM, J.V. wrote:
> How is this accomplished?
>
> Is it possible to log queries to a table with additional information?
>
> 1) num rows returned (if a select)
>
This isn't logged
> 2) time to complete the query
>
This is logged
> 3) other info?
>
> Take a look at th
---+-
public | joe | table | scott | 8192 bytes |
public | mike | table | scott | 8192 bytes |
(2 rows)
postgres=#
It's a pretty quick way to get familiar with how the catalogs are
structured. I agree that when it comes to 'getting things done',
information_sch
On Sun, Nov 20, 2011 at 6:21 AM, Marko Kreen wrote:
> On Sun, Nov 20, 2011 at 8:32 AM, Phoenix Kiula
> wrote:
> > The password I am entering in the terminal is right for sure. I've
> > tried it a few times, checked the caps lock, etc. Also, if the log
> > carries this "FATAL password authenticat
On Fri, Nov 25, 2011 at 11:05 AM, Rich Shepard wrote:
> The data originated in a spreadsheet and, based on my experience, contains
> duplicate records. After reformatting there are 143,260 rows to insert in
> the table. The approach I tried seems to have problems (explained below)
> and
> I would
On Wed, Nov 30, 2011 at 4:19 PM, panam wrote:
> Had to restart the import. This time, I tried with a smaller initial disk
> size (1GB) and extended it dynamically. It did not cause any problems.
> A different reason might be, that I remounted the volume in between during
> the last update to deac
On Thu, Dec 8, 2011 at 4:27 PM, Bruce Momjian wrote:
> Joshua D. Drake wrote:
> >
> > On 12/08/2011 12:57 PM, Bruce Momjian wrote:
> > >
> > > Chris Redekop wrote:
> > >> Is there any way to get the database system identifier via a select
> > >> statement? I have a primary/secondary async replic
On Tue, Feb 21, 2012 at 5:09 AM, sunpeng wrote:
> I try to setup warm-standby using file-based log shipping method:
> Master: 5432 port
> Standby:6432 port at same machine
> Master's :
>
>- wal_level = archive
>- archive_mode = on
>- archive_command = 'cp %p /home/postgres/archive/%f'
On Wed, Apr 18, 2012 at 7:45 PM, Jose Hales-Garcia <
jose.halesgar...@stat.ucla.edu> wrote:
>
> Hello,
>
> I'm setting up a second instance on a server. The instance versions are
> 8.3.5 (original instance) and 9.1.3 (the new instance I'm attempting to set
> up).
>
> I believe I have followed the
On Sat, Mar 28, 2009 at 3:51 AM, ray wrote:
> I have installed 8.2 on a Windows 2000 laptop.
>
> I think it is installed. From the pgAdmin, it shows "Servers (1)" and
> it is named PostgreSQL Database Server 8.2 (localhost:5432). Right
> clicking for says I can stop services or disconnect so I
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
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
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 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 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 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 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 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 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 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 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 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 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
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
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
101 - 200 of 201 matches
Mail list logo
