Hi,
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hi,
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
DROP DATABASE au_shipping
;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
ENCODING = 'SQL_ASCII';
DROP DATABASE au_test
;CREATE DATABASE au_test WITH OWNER = chriskl TEMPLATE = template0
Hi,
On Thu, 2003-01-16 at 10:13, Christopher Kings-Lynne wrote:
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
DROP DATABASE au_shipping
;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE = template0
ENCODING = 'SQL_ASCII';
DROP DATABASE au_test
You're right. It's a type in pg_dumpall.c
I have attached a fix for it.
Chris
;CREATE DATABASE keystone WITH OWNER = chriskl TEMPLATE =
template0 ENCODING
= 'SQL_ASCII';
Why are all the CREATE DATABASE statements commented out?
Surely that will
make the restore fail?
Just
On Thu, 2003-01-16 at 08:29, Mark Kirkwood wrote:
Adrian 'Dagurashibanipal' von Bidder wrote:
I'm just saying that there are
*some* small arcane details in postgres, too (although, at least, they
don't affect stability, just performance).
Indeed you are right... Pg has its own
I work in an all Oracle shop, with server instances around the world. At
least 20 servers are 400Gb+ and a couple are 4 Terabyte+. I tooks $15k worth
of Oracle training, have set up my own instances and done Perl/CGI/Apache
work along with setting up really big data warehousing apps for
Does anyone think it would be a good idea, or is it even practical, to
have a 'indx' subdirectory along side of the 'base' directory?
I was thinking that, if it were an easy modification, that it could be
an easy way to separate data and indexes to different hard disks.
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
You're right. It's a type in pg_dumpall.c
A harmless typo --- the lines aren't commented out (I think your
assembly-language background is showing ;-)). But it is pretty ugly
output all the same. Have applied the patch.
I don't think a semicolon is a comment. It causes the execution of the
previous statement.
Christopher Kings-Lynne wrote:
Hi,
In postgresql 7.3.1, if I do pg_dumpall -c, at the top of the dump file is
this:
DROP DATABASE au_shipping
;CREATE DATABASE au_shipping WITH OWNER = auadmin TEMPLATE
On Wed, 15 Jan 2003, mlw wrote:
I just wanted to post this note.
I have been in Oracle hell for four days now, and in between the 5
minutes of work and the hours of watings, dealing with table spaces,
I've been in Informix hell for the month or so.
At first, we were getting the message No
On Thu, Jan 16, 2003 at 11:17:42AM -0500, Jeff wrote:
On Wed, 15 Jan 2003, mlw wrote:
So with all that, you gotta appreciate both sides - hte fact pg just
works and the tunability of bigger db's (Oh yeah - and we've actually had
informix on the horn about the problem - their solution was
On Thu, 2003-01-16 at 17:42, D'Arcy J.M. Cain wrote:
We are also looking at hardware solutions, multi-CPU PCs with tons (24GB) of
memory. I know that memory will improve access if it prevents swapping but
how well does PostgreSQL utilize multiple CPUs?
At most one CPU is used for any
On Thu, 2003-01-16 at 11:42, D'Arcy J.M. Cain wrote:
Is [Oracle RAC] really as simple as it sounds or would we just be
giving up the other two for a new set of problems.
That's a question you should be asking to an authority on Oracle RAC
(which pgsql-hackers is not).
My idea is to create a
Due to the fact that we are growing out of our current system (PostgreSQL on
PCs) we are looking for ways to expand and one of the suggestions has been to
toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC)
software. The theory is that you can just plug machines into the
On Thu, 2003-01-16 at 13:41, Rod Taylor wrote:
ALTER TABLE .. SET WITHOUT OIDS;
I'd prefer this, as it's more similar to the CREATE TABLE syntax.
Cheers,
Neil
--
Neil Conway [EMAIL PROTECTED] || PGP Key ID: DB3C29FC
---(end of broadcast)---
On Thu, Jan 16, 2003 at 10:50:49AM -0600, Ross J. Reedstrom wrote:
suggestion to upgrade to a not yet released version invariably includes
the option of applying the patch yourself. Not something Oracle can offer.
Not for a sane price, I guess. I believe the high end support contracts
include
Rod Taylor [EMAIL PROTECTED] writes:
What is the preferred syntax:
ALTER TABLE .. DROP COLUMN oid;
or
ALTER TABLE .. SET WITHOUT OIDS;
If we ever got around to supporting the inverse function (add oids),
I do not think we'd want to spell it like ADD COLUMN oid --- that
would interfere with
mlw said:
Does anyone think it would be a good idea, or is it even practical, to
have a 'indx' subdirectory along side of the 'base' directory?
I was thinking that, if it were an easy modification, that it could be
an easy way to separate data and indexes to different hard disks.
This
Hi, we're students seeking to make a visualization of postgresql locking system.
We're currently clueless as where to find postgresql source codes.
Any help? :)
Thanks,
Nat
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
Well, it is open source, so there's no reason why someone couldn't make
these changes for 7.4 and also release a binary version in the mean time.
I have a copy of a 7.2 psql binary for linux
On Thu, 16 Jan 2003, Tom Lane wrote:
mlw said:
Does anyone think it would be a good idea, or is it even practical, to
have a 'indx' subdirectory along side of the 'base' directory?
I was thinking that, if it were an easy modification, that it could be
an easy way to separate data
Peter Eisentraut wrote:
Adrian 'Dagurashibanipal' von Bidder writes:
- postgres should auto-tune itself - the *cost could perhaps be
adjusted after some statistics have been collected, and there should be
some sensible way to determine an optimal setting for the famous
Take a look on the developers page for a few internals presentations. I
have some on my home page as well, see URL in signature.
---
Chandralaksana Natalia wrote:
Hi, we're students seeking to make a visualization of
I guess I'd prefer the DROP COLUMN syntax. It means we don't have to add
another non-standard command, and people can figure out how to drop the oid
column just by trying...
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Rod Taylor
Sent:
Hi guys,
Just received a query through the Advocacy site's request form...
Does anyone know if PostgreSQL 7.4's native windows version will/would
be compatible with Microsoft's SMS (System Management Server)?
Looks like some places will be considering it for Enterprise Deployment
if it is.
Hi everyone,
Over the last few days we've had patches submitted for 7.2.3 that
address a couple of things, both the WAL Recovery Bug that Tom has
developed a patch for, and a couple of buffer overflows that have been
widely reported.
Although we haven't wanted to release a 7.2.4, and have
Currently, the default sysid assigned to a user or group is computed as
max(sysid)+1. We've seen a couple of complaints now from people who
deleted their newest user, made another user, and found that permissions
from the deleted user carried over to the new one.
It seems to me that the easiest
On 17 Jan 2003 at 1:16, Tom Lane wrote:
Currently, the default sysid assigned to a user or group is computed as
max(sysid)+1. We've seen a couple of complaints now from people who
deleted their newest user, made another user, and found that permissions
from the deleted user carried over to
Fred Zellinger wrote:
I also am a Linux Nut and use Postgres whenever possible because I like the
freedom of access to the HACKERS mailing list...something only a few highly
renound DBA snobs have with Oracle.
Indeed, I think this is a significant component of the appeal of open
source
I
Adrian 'Dagurashibanipal' von Bidder writes:
- postgres should auto-tune itself - the *cost could perhaps be
adjusted after some statistics have been collected, and there should be
some sensible way to determine an optimal setting for the famous
shared_buffers (and the default should be
Bruce Momjian writes:
I think the one missing item mentioned was for group ownership of an
object. However, if we give group _permission_ to the object, I am not
sure why ownership is an issue. Are there certain permission we can't
give to the group?
Privilege to rename or drop the object,
Peter Eisentraut [EMAIL PROTECTED] writes:
Is there really a reason why OIDs can't be a pure user-space column?
We'd need some kluge to keep SELECT * from including OID. Also I'd be
a bit worried about the impact on the cost of HeapTupleGetOid --- it
might not matter, or it might.
Tom Lane writes:
If we ever got around to supporting the inverse function (add oids),
I do not think we'd want to spell it like ADD COLUMN oid --- that
would interfere with making a plain user column named oid, which was
one of the reasons why people wanted to be able to drop OIDs in the
Due to the fact that we are growing out of our current system
(PostgreSQL on
PCs) we are looking for ways to expand and one of the suggestions
has been to
toss PostgreSQL in favour of Oracle with Remote Access Cluster (RAC)
software.
You mean Real Application Clusters?
Chris
Hi everyone,
Christian Kuroki [EMAIL PROTECTED] is a senior member of a team that
is translating the PostgreSQL manuals to Spanish.
There isn't a website for it yet (it will be created fairly soon) but
the team is making good progress, and the manuals will be kept updated
with the main
35 matches
Mail list logo