Hello everybody, i really need to know hardware requirements for installing
PostgreSQL 8.0.3.
I'm in a database migration project and it is important to work with the
appropiate hardware.
DB must work in windows. There are 50 tables aprox and data size is near 6
GB. Thank for your answers.
PGAdmin II had a "Migration Wizard" plugin that did a great job. I used
it a lot to convert MS SQL 7 and 2000 db's to Postgres 7.x.
It did
not convert views, but I wrote some code that did that.
Unfortunately, PGAdmin II doesn't work with PG 8.
And
PGAdmin III doesn't have the Migration
am 28.09.2005, um 22:48:06 -0700 mailte TheNice Spider folgendes:
Hi,
Currently I have serious problem to migrate a production MS SQL 2K to
Postgres 8 for Windows.
Is there any tools to import MS SQL 2K to Postgres 8 including:
- PK and FK
- View, Trigger, Store Procedure
- Username
Unless you need all that data in ram (and you probably don't), then
any machine should be capable. The real questions are, how many
concurrent clients? How static is the data? What is your query
complexity?
On Sep 28, 2005, at 11:08 PM, Rafael Montoya wrote:
Hello everybody, i really need
Ok, there are about 15 concurrent clients inserting and updating data, and
20 concurrent clients only consulting.
I dont need all data in ram, of course, hehe, but i really have no idea
what's the minimum of ram for having fast answers for about 2000
transactions in a day.
Almost all queries
Hello,
We use i686 based linux RH9.0 system and our
postgresql is 8.0.3
We use following command
su -c '/usr/local/pgsql/bin/pg_dump -d -O -x[DBNAME] [file
withpath]' postgres
to generate dump.
But while restoring it gives too many errors and
that is because it uses $_$ for plpgsql
I have a program that reads data from Postgresql database (version
8.0.3) through ODBC, but data retrieval is pretty slow. When I type the
same SQL sentence in pgadmin III or any other sql tool it is much
faster, and typing 'explain' clearly shows that it is using index.
However the program is
am 29.09.2005, um 9:20:00 +0200 mailte Rafael Montoya folgendes:
Ok, there are about 15 concurrent clients inserting and updating data, and
20 concurrent clients only consulting.
I dont need all data in ram, of course, hehe, but i really have no idea
what's the minimum of ram for having
On Thu, Sep 29, 2005 at 09:20:00AM +0200, Rafael Montoya wrote:
Ok, there are about 15 concurrent clients inserting and updating data, and
20 concurrent clients only consulting.
I dont need all data in ram, of course, hehe, but i really have no idea
what's the minimum of ram for having fast
Dragan Matić wrote:
I have a program that reads data from Postgresql database (version
8.0.3) through ODBC, but data retrieval is pretty slow. When I type
the same SQL sentence in pgadmin III or any other sql tool it is much
faster, and typing 'explain' clearly shows that it is using index.
Partners - Majolee InfoTech wrote:
Hello,
We use i686 based linux RH9.0 system and our postgresql is 8.0.3
But while restoring it gives too many errors and that is because it
uses $_$ for plpgsql function body separator which the pg_restore and
psql [dbname] [file] both does not seem to
Just for the record, and put some closure, today I finaly got unstable
packages for postgresql-8.0 (up to yesterday the unstable package was the
same as the testing one on SPARC) and this problem creating views is gone.
From the changelog it looks like a bus error:
postgresql-8.0 (8.0.3-16)
David Garamond [EMAIL PROTECTED] writes:
Hi,
Our current project requires a fine-grained permission system (row-level
and possibly column-level as well). We have a pretty large (tens of
thousands) of users in the 'party' table. I'm thinking of choosing
Unix-style security for now (adding
Hi,
I'd really like to aviod another list (ie. interfaces) if at all possible, so...
Got a script (trimmed version below) that starts to have exponential memory use
after a number of iterations around the while(($sth-fetch())) { } struct.
Table is quite small (520 odd rows) and the row
Is there any support for perl regular expressions
in Postgresql?
--
http://www.spinics.net/yosemite/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Hi folks at pgsql.admin,
I've Postgres 8.0.1 running natively under Windows XPpro SP2. I would
like to update to 8.0.3 using the upgrade-batchfile coming with the
zipped download file.
The installation stops when trying to install the service, saying the
Postgres 8.0 Database Service could not be
am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes:
Is there any support for perl regular expressions
in Postgresql?
Yes, you can use perl regex in plperl.
http://www.postgresql.org/docs/current/static/plperl.html
Regards, Andreas
--
Andreas Kretschmer(Kontakt: siehe
On 9/28/05 6:25 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Is there any support for perl regular expressions
in Postgresql?
You might want to look at this section of the documentation:
http://www.postgresql.org/docs/8.0/interactive/functions-matching.html
Sean
Hi folks at pgsql.admin,
I've Postgres 8.0.1 running natively under Windows XPpro SP2.
I would like to update to 8.0.3 using the upgrade-batchfile
coming with the zipped download file.
The installation stops when trying to install the service,
saying the Postgres 8.0 Database Service
A. Kretschmer schrieb:
am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes:
Is there any support for perl regular expressions
in Postgresql?
Yes, you can use perl regex in plperl.
http://www.postgresql.org/docs/current/static/plperl.html
And in plpythonu too ;)
Part of
On Thu, Sep 29, 2005 at 07:38:38AM -0300, Martín Marqués wrote:
Just for the record, and put some closure, today I finaly got unstable
packages for postgresql-8.0 (up to yesterday the unstable package was the
same as the testing one on SPARC) and this problem creating views is gone.
From
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Any ideas please? This seems well weird to me, but...
I could not duplicate this. Can you provide a self-contained test case?
It's not useful if we don't know what's actually in the table and what
the table structure looks like.
- --
Greg Sabino
am 29.09.2005, um 9:14:39 -0400 mailte Sean Davis folgendes:
On 9/28/05 6:25 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Is there any support for perl regular expressions
in Postgresql?
You might want to look at this section of the documentation:
On Thu, 2005-09-29 at 08:30, Tino Wildenhain wrote:
A. Kretschmer schrieb:
am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes:
Is there any support for perl regular expressions
in Postgresql?
Yes, you can use perl regex in plperl.
On Sep 29, 2005, at 8:38 AM, Bob Parkinson wrote:
Upgraded PG to 8.0.3, DBI to 1.48 and DBD::Pg to 1.43 this morning,
but made no difference. FreeBSD 5.4 (they'll get it right
RSN :- )), perl 5.8.2
I've had bad mem leaks on FreeBSD with perl 5.8.6. Try upgrading
that as well.
I'm attempting to build the srpm (postgresql-8.0.1-2PGDG.src.rpm), but
am running into a snag with krb5.h. The configure script doesn't see it
although I have krb5-devel installed and the file exists in
/usr/kerberos/include/. Anyone have a clue what I should do? (I'm using
rpmbuild
Hi,
On Thu, 29 Sep 2005, Shane Dawalt wrote:
I'm attempting to build the srpm (postgresql-8.0.1-2PGDG.src.rpm), but am
running into a snag with krb5.h. The configure script doesn't see it although
I have krb5-devel installed and the file exists in /usr/kerberos/include/.
Anyone have a clue
Scott == Scott Marlowe [EMAIL PROTECTED] writes:
Scott And you can use perl regex in PHP as well, since it supports the PCRE
Scott lib.
Well, *almost* Perl. Despite its name, PCRE is a misnomer, since it's
not really Perl and it's not entirely compatible. :) Yes, it's a
powerful regular
=?UTF-8?B?RHJhZ2FuIE1hdGnEhw==?= [EMAIL PROTECTED] writes:
I have a program that reads data from Postgresql database (version
8.0.3) through ODBC, but data retrieval is pretty slow. When I type the
same SQL sentence in pgadmin III or any other sql tool it is much
faster, and typing
On 9/28/2005 5:44 AM, Wijnand Wiersma wrote:
Hi list,
I am currently trying to give normal users some read access to some
tables in the database. I also need to give update access to one
column of one table.
I have the table contact, the user should not be able to read or
update anything in
on 9/29/05 6:38 AM, [EMAIL PROTECTED] purportedly said:
Any ideas please? This seems well weird to me, but...
Assuming the code snippet is representative, a couple things:
1. $dbh-prepare($stmt)-execute () || die;
This is mostly a point of protocol, but I can't resist pointing it out.
On Tue, Sep 27, 2005 at 01:34:37PM +0200, Yonatan Ben-Nes wrote:
Based on http://lnk.nu/developer.postgresql.org/44b.c, line 1478 on,
there's not a lot that happens during the ALTER TABLE. Likewise DROP
(line 517) doesn't do much either. So basically, anything trying to
access the old table
Hi
What is the best tool for debugging pl/pgsql
functions?
Any suggestions would be appreciated
Thanks
Craig
On Tue, Sep 27, 2005 at 10:24:02AM +0200, Csaba Nagy wrote:
Hi all,
I've recently asked a similar question, which received no useful answer
yet, so I'll drop in too.
In my case, the table I was inserting to was a quite big one already to
start with (and analyzed so), so I was expecting
If i have a pg_dump that is using COPY, and midway through the copy an
insert fails due to a unique constraint, will the COPY continue with the
rest of the records, or will it abort? If it aborts, will it perform a
rollback on the inserts up to that point?
thanks,
reid
Devrim GUNDUZ wrote:
On Thu, 29 Sep 2005, Shane Dawalt wrote:
I'm attempting to build the srpm (postgresql-8.0.1-2PGDG.src.rpm),
but am running into a snag with krb5.h. The configure script doesn't
see it although I have krb5-devel installed and the file exists in
/usr/kerberos/include/.
Hi guys,
I'd really appreciate if you could clarify this to me. Let's say I have
a table named TABLE_A that is a bridge to many-to-many relationship
between TABLE_B and TABLE_C, as such here is my declaration:
CREATE TABLE table_a (
table_b_id INT4NOT NULL
On Thu, Sep 29, 2005 at 08:08:17PM +0200, Craig wrote:
Hi
What is the best tool for debugging pl/pgsql functions? Any
suggestions would be appreciated
For now, it's RAISE NOTICE aka debugging by printf, and I'm
checking out EMS HiTech's debugger, which is part of their toolset.
am 29.09.2005, um 20:08:17 +0200 mailte Craig folgendes:
Hi
What is the best tool for debugging pl/pgsql functions?
Any suggestions would be appreciated
RAISE NOTICE 'foo %', bar;
Read: http://www.postgresql.org/docs/8.0/static/plpgsql-structure.html
Regards, Andreas
--
Andreas
The security documentation available in the official documentation is
rather sparse. Is there a more detailed document I should be aware of?
As an example, I'd like to prevent a a user from being able to get a
list of existing databases. Presumably, I can limit access to various
system catalogs
On Thu, 2005-09-29 at 14:28, Reid Thompson wrote:
If i have a pg_dump that is using COPY, and midway through the copy an
insert fails due to a unique constraint, will the COPY continue with the
rest of the records, or will it abort? If it aborts, will it perform a
rollback on the inserts up
On Sep 29, 2005, at 1:23 PM, Keary Suska wrote:
You should always finish() every select statement handle, or both
DBI and
libpq will leak:
$sth-finish;
after the closing bracket of the while() loop.
No, you don't need to call finish() if you fall off the end of a
while
On Tue, Sep 27, 2005 at 09:07:41AM -0500, boinger wrote:
- Index Scan using strafe_group on tasks_applied
(cost=0.00..6.02 rows=1 width=22) (actual time=0.042..0.043 rows=0
loops=1188)
Index Cond: (((outer.modcode)::text =
(tasks_applied.modcode)::text)
On Mon, Sep 26, 2005 at 07:16:53PM -0700, Qingqing Zhou wrote:
Brandon Metcalf [EMAIL PROTECTED] wrote
Is there a way to check for the existence of a column in a table other
than, say, doing a SELECT on that column name and checking the output?
Take a look at pg_attribute system
On Tue, Sep 27, 2005 at 03:09:43PM +0530, surabhi.ahuja wrote:
is it some logging information that is being written into some file at the
end of some transactions
(each intsall is one transaction for me)
the data directory is containing these folders..
base/pg_clog/
Hi,
You cannot actually say that do is more correct than prepare/execute (for
a non-select statement), because do is just a shortcut. According to the
DBI documentation, it does a prepare and execute for you. In fact, if you
look at the DBI.pm code, that is what it is doing. I do agree that
Hi,
I am trying to get some information on using DBLINK
on windows?
I am not having much luck searching the
forums/google.
Has anyone been using DBLINK on Windows. I
amUsing 8.03 on Windows
2000.
Ideally I would like to be able to send data from
postgres to and from ODBC compliant
SELECT c.name, w.ib, c.vbp, c.year_balance
FROM clients c
LEFT JOIN workers w ON (w.client_id = c.id)
;
Will do the trick.
BTW, I suggest not using 'bareword' id's for field names. It's very easy
to get confused with larger queries. So instead of clients.id, do
clients.client_id. I
when i grep for postmaster
ps -aef | grep postmaster
it says:
/usr/bin/postmaster -D
/export/home1/sdc_image_pool/dbx -p 5432
when i try to stop postmaster doing
/usr/bin/pg_ctl -D
/export/home1/sdc_image_pool/dbx/ stop
the following is displayed:
waiting for postmaster to shut
49 matches
Mail list logo