From: [EMAIL PROTECTED]
To:
Subject: [ADMIN] Correct configuration to access Postgres 7.3 from remote
client?
Date: Tue, 3 Jul 2007 20:42:27 -0400
First, I modified these lines in the postgresql.conf file:
tcpip_socket = true
port = 5432
virtual_host = '20.20.20.4, localhost'
You can mak
No, you can do with it whatever you want, except blame/sue the copyrightholder
for any problems you might have with it (software is AS IS).
On Thursday 05 July 2007, lai yoke hman wrote:
> Hello,
> I am an undergraduate of a university in Malaysia, if I want to do
> performance benchmark on Post
lai yoke hman wrote:
>
> Hello,
> I am an undergraduate of a university in Malaysia, if I want to do
> performance benchmark on PostgreSQL 8, do I need to get a license agreement
> or some sort of thing?
> Thanks.
No. PostgreSQL is open source.
Joshua D. Drake
>
>
>
Hello,
I am an undergraduate of a university in Malaysia, if I want to do performance
benchmark on PostgreSQL 8, do I need to get a license agreement or some sort of
thing?
Thanks.
_
Check out some new online services that are so
"Martin Arpon" <[EMAIL PROTECTED]> writes:
> I have a filesystem backup (cold - database was not running) of only a
> single tablespace where the database was sitting.
> Is it possible to install a new instance of PostgreSQL and in some way
> "re-mount" this tablespace recovering the database that
Hi,
I have a filesystem backup (cold - database was not running) of only a
single tablespace where the database was sitting.
Is it possible to install a new instance of PostgreSQL and in some way
"re-mount" this tablespace recovering the database that was there?
The whole database was there, and
On Tue, Jul 03, 2007 at 08:15:35AM +0800, Yuan HOng wrote:
> sites shall update these tables, and the link is over a WAN, it seems
> the most appropriate replication solution would be a multi-master,
> asynchronous solution.
Yes, that would be best.
> be to use a separate table for order on web s
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> As far as getting out of the situation, the only really good answer is a
>> dump and reload. I can't think of any simple way of getting rid of the
>> bogus row, but what you should be able to do to let pg_dump work is to
>> rename mis
On 7/5/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
Creatred a group, added members to the group, what command to use to check
the current members in the group? thanks.
You can query group related information from the pg_group view. The
'grolist' parameter would contain an array of the sys
Carol Walter wrote:
Hello,
My supervisor has requested that I copy a small database to Excel for
her to look at. The first time I did it, I used the copy command and
the data was so dirty that it didn't come in very well. Someone
suggested that I use a pipe to delimit the data so that the E
Hello,
My supervisor has requested that I copy a small database to Excel for
her to look at. The first time I did it, I used the copy command and
the data was so dirty that it didn't come in very well. Someone
suggested that I use a pipe to delimit the data so that the Excel can
ignore
Tom Lane wrote:
> "James Wilford" <[EMAIL PROTECTED]> writes:
> > It's a redhat version of 7.3 - rh-postgresql-server-7.3.8-2 is the
> > package.
>
> That was obsoleted by Red Hat well over two years ago; you are overdue
> for an update.
>
> >xmin |cmin|xmax| cmax | oid
"James Wilford" <[EMAIL PROTECTED]> writes:
> It's a redhat version of 7.3 - rh-postgresql-server-7.3.8-2 is the
> package.
That was obsoleted by Red Hat well over two years ago; you are overdue
for an update.
>xmin |cmin|xmax| cmax | oid| ctid | datname
> --
[EMAIL PROTECTED] ("Yuan HOng") writes:
> It seems Slony-II would be quite promising, but I can't wait that
> long. What is the best choice for me now?
Worth noting: Slony-II would never have been suitable, as it would
have required that all the "master" servers be in the same data
centre.
I don'
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: 05 July 2007 17:27
To: James Wilford
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] More than one pg_database entry for database
"James Wilford" <[EMAIL PROTECTED]> writes:
> Its PG version 7.3.
Please tell us it'
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: 05 July 2007 15:53
To: James Wilford
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] More than one pg_database entry for database
"James Wilford" <[EMAIL PROTECTED]> writes:
> This shows 2 entries for "misp" with diff
Hello
I match the problem : a trigger writed in PL::Ruby
If I remove the trigger ok.
but I don't know how fix it.
De Leeuw Guy a écrit :
> Hello,
>
> I try to copy a file into a database :
> On our main server (postgresql 8.1 debian etch ia64) no problem.
> On a test laptop (postgresql 8
"James Wilford" <[EMAIL PROTECTED]> writes:
> Its PG version 7.3.
Please tell us it's a relatively recent 7.3.x, at least ...
> I've just tried all your suggestions and
> unfortunately I still can't delete the bogus row. I think I managed to
> reindex the system tables:
Curious. I'd have though
Creatred a group, added members to the group, what command to use to check the
current members in the group? thanks.
-
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
"James Wilford" <[EMAIL PROTECTED]> writes:
> This shows 2 entries for "misp" with different OIDs. Only the first one
> (oid 31238435) exists in the data/base directory. So I tried to delete
> the other row but it doesn't work:
> misp=# DELETE from pg_database where oid = 6790290;
> DELETE 0
That
Hi all,
I'm trying to do a pg_dump of my database but I'm getting this error:
# pg_dump misp > misp.sql
pg_dump: query returned more than one (2) pg_database entry for database
"misp"
I can connect to the database OK, I just can't dump it. So I connected
as postgres to look at the pg_database ta
First, I modified these lines in the postgresql.conf file:
tcpip_socket = true
port = 5432
virtual_host = '20.20.20.4, localhost'
where 20.20.20.4 is the address of the postgres server. Is this needed?
Second, I modified pg_hba.conf and added this line:
host all all 20.20.20.5 255.255.2
Sorry I forgot the subject.
Hi, list,
Can you give me some suggestions as to what replication solution best
suits my situation:
I have an online product sales applicaiton, which is split between two
sites. The web front-end sits at the ISP's data center and accepts
customer order. The server in
Greetings All,
I'm working on a specification for an Enterprise-class Open Source
batch scheduler, and I really would like some expert commentary from
experienced database people. Please have a look at:
http://openjcs.sourceforge.net
and the specification to date at:
http://openjcs.sourceforge.
carl <[EMAIL PROTECTED]> writes:
> Greetings All,
>
> I'm working on a specification for an Enterprise-class Open Source
> batch scheduler, and I really would like some expert commentary from
> experienced database people. Please have a look at:
>
> http://openjcs.sourceforge.net
>
> and the specif
Hello,
I try to copy a file into a database :
On our main server (postgresql 8.1 debian etch ia64) no problem.
On a test laptop (postgresql 8.2 debian testing lenny ia32) I
receive the error :
the size of the array exceed the maximum allowed (268435455)
db_stats=# COPY table_cat FRO
26 matches
Mail list logo
