> I need some advice.. I am new to PG8 - I am working on the project
> that needs to load data daily to PostgreSQL from the text file.. the
> text file is 40MB comma delimited file with row consisting of 20-30
> fields and couple thousands of rows..
>
> so the data needs to be parsed and if the ro
On Fri, 2005-02-18 at 20:34 -0500, Paul R wrote:
> I need some advice.. I am new to PG8 - I am working on the project
> that needs to load data daily to PostgreSQL from the text file.. the
> text file is 40MB comma delimited file with row consisting of 20-30
> fields and couple thousands of rows..
On Saturday 12 February 2005 4:09 pm, Bruce Momjian wrote:
> Added to TODO:
>
> * Add IP address to pg_stat_activity
I like it. How about IP and port to differentiate multiple connections
from the same host? Will this support IPV6?
Cheers,
Steve
---(end of broadca
I need some advice.. I am new to PG8 - I am working on the project
that needs to load data daily to PostgreSQL from the text file.. the
text file is 40MB comma delimited file with row consisting of 20-30
fields and couple thousands of rows..
so the data needs to be parsed and if the row exists it
OK, it appears I can reproduce this bug in fairly short
order. Below are gdb backtraces along with current
snapshots from ps, netstat, and a snippet of the server
log. This is no longer an urgent issue for me with the
gcc 3.4.2 workaround available, but I do have a stalled
test cluster postmaste
Here's the lsof output for the hung processes...
$ lsof | egrep 'PID|28775|29080|26752'
COMMANDPID USER FD TYPE DEVICE SIZE/OFF NODE NAME
psql 26752 pg cwdDIR 64,0x9 204812677 /users/pg
psql 26752 pg txtREG 64,0x6 242
Thank you for the links.
Based on the resources and reviews I found online, Slony looks like
the best solution. Am disappointed that these systems are not better
reviewed online (it really helps with convincing management). We sold
them on postgresql, but we need to sell them that the replication
Dear Richard:
1.Thank you for reply
2.Dear Richard,I must write a Makefile for my client packge.But i don't
know on pgsql's library & path of its include-files.
Please guide me on writting a Makefile for a client packege with pgsql.
Yours,Mohsen
> Mohsen Pahlevanzadeh wrote:
>> I know about Makefil
On Fri, 18 Feb 2005 13:51:00 -0800, Wang, Mary Y <[EMAIL PROTECTED]> wrote:
>
>
> Hi All,
>
> I have been using PostgreSQL for my project repository, because it is free
> and easy to use. My manager is trying to decide if he should use a
> commercial database such as Oracle or PostgreSQL f
On Fri, 2005-02-18 at 15:51, Wang, Mary Y wrote:
> Hi All,
>
> I have been using PostgreSQL for my project repository, because it is
> free and easy to use. My manager is trying to decide if he should use
> a commercial database such as Oracle or PostgreSQL for a giant
> information repository f
Title: Message
Hi
All,
I have been using
PostgreSQL for my project repository, because it is free and easy to use.
My manager is trying to decide if he should use a commercial database such as
Oracle or PostgreSQL for a giant information repository for the corporate.
He asked me what i
Title: Message
Hi
All,
I have been using
PostgreSQL for my project repository, because it is free and easy to use.
My manager is trying to decide if he should use a commerical database such as
Oracle or PostgreSQL for a gaint information repository for the corporate.
He asked me what is
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (John
Sidney-Woollett) transmitted:
> Try this for starters - it's a good introductory article
>
> http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
>
> Maybe someone else can provide other links.
See also the URL belo
Tom suggested:
> You seem to have a miscompiled backend. Where did you get the
> installer from? Maybe a bad download?
I snagged the non-Japanese version from:
http://www.postgresql.org/ftp/win32/
___
No banners. No pop-ups. No kidding.
Make My Way y
On Friday February 18 2005 11:01, Ed L. wrote:
> it could be a problem with the
> build since the 7.4.6 build that was hanging was built with
> gcc 3.2.2, while the 7.4.6 builds on two other identical boxes
> were built with gcc 3.4.2. So we shutdown all the 7.4.6
> clusters, rebuilt using gcc 3.4
On Fri, 18 Feb 2005 10:15:21 -0800, Joshua D. Drake
<[EMAIL PROTECTED]> wrote:
>
> > The first three are all open source, the last one is not, but the source
> > code is available to customers, and should the project be abandoned or
> > the company go under it is promised to be released under an o
Carlos Henrique Reimer <[EMAIL PROTECTED]> writes:
> I´m trying to restore a client cluster in my Linux box but during the restore
> the following error is reported:
> ALTER USER "BENK" SET search_path TO '"BENK", public, pg_catalog';
> psql:dumpall7.4.6_0902:14: ERROR: schema ""BENK", public, p
Agreed, the EMS product really is a slick tool. On another front, somewhere
on my todo list is to add database diffing abilities to phppgadmin. There's
a multiple db connection patch floating around that looks like it will be a
help; if I can clear my schedule up enough I might get back to th
On Fri, Feb 18, 2005 at 10:05:25AM -0200, alexandre::aldeia digital wrote:
> IBM DB2 have functions that allow the DBA to disconnect some clients.
> This is very usefull for database maintenance without giving a shell to him.
As I mentioned, you could write a function in C, PL/Perl, etc.,
that s
The first three are all open source, the last one is not, but the source
code is available to customers, and should the project be abandoned or
the company go under it is promised to be released under an open source
license. Cost is $1,000.
Just FYI: Not only is it promised :) It is stated in the
Clemens Wehrmann <[EMAIL PROTECTED]> writes:
> I am trying to debug a postgresql server crash and am out of my depth.
I think you're doing pretty well, actually ...
> Selecting works for records where offset < 129833, but is broken for the next
> record.
You mean offset < 129831, no? At least t
"S.D." <[EMAIL PROTECTED]> writes:
> I downloaded the native Windows 8.0.1 installer and sorted through the
> various Windows permissions problems by running the Installer as an admin but
> not creating a cluster. Then I log out and log back in as the limited
> "postgres" user and run initdb.exe
On Wednesday February 16 2005 3:38, Martijn van Oosterhout wrote:
> On Wed, Feb 16, 2005 at 11:41:35AM -0700, Ed L. wrote:
> > Question: Am I doing all I can to avoid corruption with the
> > following procedure to shutdown a 7.4.6 cluster with a hung
> > postmaster? Suggestions?
>
> What is the s
Hi,
I´m trying to restore a client cluster in my Linux box but during the restore the following error is reported:
__
DELETE 0CREATE USER '\set ON_ERROR_STOP 'true' PostgreSQL database cluster dump--\connect "template1"You are now conne
I downloaded the native Windows 8.0.1 installer and sorted through the various
Windows permissions problems by running the Installer as an admin but not
creating a cluster. Then I log out and log back in as the limited "postgres"
user and run initdb.exe from the command line. Initdb creates the
On Fri, 2005-02-18 at 11:17, Dieter SchrÃder wrote:
> On Fri, 18 Feb 2005 10:58:08 -0600, Scott Marlowe
> <[EMAIL PROTECTED]> wrote:
> > On Fri, 2005-02-18 at 10:40, Dieter SchrÃder wrote:
> > > Hello all,
> > >
> > > I am currently migrating a few oracle servers to postgre sql and
> > > management
I am trying to debug a postgresql server crash and am out of my depth. The
server is sent a segmentation fault when accessing certain data. I've
tracked down one such place (though there may be others). I'm wondering if
its possible for a more experienced person to see from the below if I'm
Alex Turner <[EMAIL PROTECTED]> writes:
> Is there any way to get the list of locks by transation id or some
> other datum to indicate which was first, or to figure out which is the
> lock that is holding everything else back?
Perhaps get some stats on the rows with granted=f to see what seems to
On Fri, 18 Feb 2005 10:58:08 -0600, Scott Marlowe
<[EMAIL PROTECTED]> wrote:
> On Fri, 2005-02-18 at 10:40, Dieter Schröder wrote:
> > Hello all,
> >
> > I am currently migrating a few oracle servers to postgre sql and
> > management wants us to have replication. We have found information
> > about
Try this for starters - it's a good introductory article
http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
Maybe someone else can provide other links.
John Sidney-Woollett
Dieter Schröder wrote:
Hello all,
I am currently migrating a few oracle servers to postgre sql and
management wants us t
Mohsen Pahlevanzadeh wrote:
I know about Makefile,But i need to write a Makefile that i can
communicate with pgsql & its library & header file from C++.
I'm afraid I still don't understand what you mean. If you are looking
for C++ libraries so you can access a PostgreSQL database, then you
probab
On Fri, 2005-02-18 at 10:40, Dieter SchrÃder wrote:
> Hello all,
>
> I am currently migrating a few oracle servers to postgre sql and
> management wants us to have replication. We have found information
> about the slony replicator with blog posts and articles. We have not
> found any other replic
Dieter,
Slony is the most active replication project and it looks like it is the
most used lately, but if it is the best for you depends on what you
need, as there's no "one size fits all" replication solution.
If you want master-slave asynchronous replication with only one master
and few possibly
Hello all,
I am currently migrating a few oracle servers to postgre sql and
management wants us to have replication. We have found information
about the slony replicator with blog posts and articles. We have not
found any other replication systems reviewed, so it slony the best
tool for the job?
Benjamin wrote:
Thanx for the pointers, Richard.
If the async feature is used on the primary, shud we
copy on the xlog and clog files onto the backup as
well?
What is the "async feature"?
I meant fsync.
I meant to ask, if FSYNC is enabled, is all pending data written onto
the disk?
Yes. Turn it
I know about Makefile,But i need to write a Makefile that i can
communicate with pgsql & its library & header file from C++.
> Mohsen Pahlevanzadeh wrote:
>> Dears,
>> I'm writting a package which is pgsql-base under RH9.
>> I need to a small Makefile for compiling my package.
>> Please guide me..
I'm having a bear of a time with an application where one thread seems
to be keeping a lock on a table after it's supposed to release it.
select count(*) from pg_locks gives:
6816
Is there any way to get the list of locks by transation id or some
other datum to indicate which was first, or to fig
Thanx for the pointers, Richard.
If the async feature is used on the primary, shud we
copy on the xlog and clog files onto the backup as
well?
What is the "async feature"?
I meant fsync.
I meant to ask, if FSYNC is enabled, is all pending data written onto
the disk?
As of now, we shut down pos
Mohsen Pahlevanzadeh wrote:
Dears,
I'm writting a package which is pgsql-base under RH9.
I need to a small Makefile for compiling my package.
Please guide me
Can you give more information about what you're trying to do?
Do you need general Makefile help, or are you having problems linking to
P
Hello,
I have problem to configure postgers datasource for
WebSphere Application Server 6 (WAS6) from admin console.
1.) I have configured new JDBC Provider for PostgreSQL as
following:
Name: Postgres JDBC Provider
Class path: ${UNIVERSAL_JDBC_DRIVER_P
Dears,
I'm writting a package which is pgsql-base under RH9.
I need to a small Makefile for compiling my package.
Please guide me
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/f
On Fri, 18 Feb 2005, Bob Hartung wrote:
Hi again all.
Here is the situation:
Fedora Core 3 with all updates.
PostgreSQL 8.0.1 installed - no tables to update.
In /etc/profile I have declared:
PGDATA=/pg_data
PATH=$PATH:$PGDATA
Bob Hartung <[EMAIL PROTECTED]> writes:
>Here is the situation:
> Fedora Core 3 with all updates.
> PostgreSQL 8.0.1 installed - no tables to update.
> In /etc/profile I have declared:
> PGDATA=/pg_data
You're being bit by SELinux. Either take it out of enforce
You should be able to use a CASE WHEN statement inside this expression and
test for a null itemIdValue. If it is null the you can return ''NULL'' else,
return itemIdValue.
HTH
On Friday 18 February 2005 09:07 am, David Gagnon saith:
> Hi all,
>
> I did a stored procedure and ran into this sma
Hi all,
I did a stored procedure and ran into this small problem.
Here itemIdValue may be null and I would have expected quote_literal to
returns null as a string or the value quoted. For now I think it returns a
real null. This causes my function to crash.
insertStatement:= ''INSERT INTO
Benjamin wrote:
Hello everyone,
The scene :
Currently, we r using, Postgresql v 7.3, on RedHat 9
machines.
We provide a hot standby at all times for the Primary
server.
So, we have to maintain a duplicate of the entire
database.
The problem arises, when the standby boots.
I wanted to know, whenev
Hi again all.
Here is the situation:
Fedora Core 3 with all updates.
PostgreSQL 8.0.1 installed - no tables to update.
In /etc/profile I have declared:
PGDATA=/pg_data
PATH=$PATH:$PGDATA
export PGDATA
export P
I have a few questions regarding (or related to) the recent
SELECT INTO fixes in plpgsql.
* There hasn't been an official announcement as far as I can tell.
All I could find is a mention in David Fetter's Weekly News.
Is the risk so low it doesn't warrant informing users?
* What are the plans
Hi Michael,
The software was generated by a CASE tool (genexus) and it's does not
permit any modification.
IBM DB2 have functions that allow the DBA to disconnect some clients.
This is very usefull for database maintenance without giving a shell to him.
VACUUM FULL is other "application" thats
Hello everyone,
The scene :
Currently, we r using, Postgresql v 7.3, on RedHat 9
machines.
We provide a hot standby at all times for the Primary
server.
So, we have to maintain a duplicate of the entire
database.
The problem arises, when the standby boots.
I wanted to know, whenever the standby b
Michael Fuhr wrote:
On Thu, Feb 17, 2005 at 07:31:42PM +0100, Martijn van Oosterhout wrote:
On Thu, Feb 17, 2005 at 11:03:58AM -0700, Michael Fuhr wrote:
In experiments I've defined a domain's CHECK expression to call a
function that makes queries. It worked in simple tests; I don't
know if it'll
51 matches
Mail list logo
