I have reviewed the online documentation for PostgreSQL 7.1 for
backup/recovery. This covers the backup of the tables and their contents.
For my backup I wish to include as much as possible to limit the
consequences of a complete failure. From reviewing the archives I have
found the following sh
Why is this so very commonly used word reserved?
Is that some kind of #define so you easily can recompile
PostgreSQL? If so, please guide me to the place. This is
truly annoying.
Thanks!
Daniel Åkerud
---(end of broadcast)---
TIP 2: you can get
Forgott to say that I try to create a table named
user.
> Why is this so very commonly used word reserved?
> Is that some kind of #define so you easily can recompile
> PostgreSQL? If so, please guide me to the place. This is
> truly annoying.
>
> Thanks!
>
> Daniel Åkerud
>
Hello,
I have ported a database from MS SQL Server to PostgreSQL. The database has
40 tables and 117 indexes which I defined for the same fields as in MS SQL.
I converted the data using some SQL output from MS SQL server and inserted
it with psql.
Now I started some performance comparisons and
On Mon, 10 Sep 2001 [EMAIL PROTECTED] wrote:
> Use explain. Explain tells you the query plan of the optimizer.
>
> explain SELECT .;
Thanks I just found the thread "Index usage question" and tried to make
some profit from it:
explain SELECT Hauptdaten_Fall.MeldeKategorie, Count(Hauptdaten_Fa
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Mon, 10 Sep 2001, Tille, Andreas wrote:
> Hello,
>
> Now I started some performance comparisons and did the following statement:
> The MS-SQL server represents the result "immediately" - you just not notice
> any delay. If I do it on the PostgreSQL server it takes 30s on comparable
> hardwa
Hi All
I need to do dumps for backups from a redhat6.2 mechine.
I dont want to install the whole server for just one utility nor could I
find a proper rpm.
Any sugestions ?
the server 7.1.3 is on redhat 7.1
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Mich
On Mon, 10 Sep 2001, Tille, Andreas wrote:
> On Mon, 10 Sep 2001 [EMAIL PROTECTED] wrote:
>
> > Use explain. Explain tells you the query plan of the optimizer.
> >
> > explain SELECT .;
> Thanks I just found the thread "Index usage question" and tried to make
> some profit from it:
>
> exp
On Monday 10 September 2001 10:24 am, Ben-Nes Michael wrote:
> I need to do dumps for backups from a redhat6.2 mechine.
> I dont want to install the whole server for just one utility nor could I
> find a proper rpm.
I currently am not building Red Hat 6.2 RPMs. If you can get RH 6.2 binary
RPM
On Mon, 10 Sep 2001, Tille, Andreas wrote:
> Hello,
>
> I have ported a database from MS SQL Server to PostgreSQL. The database has
> 40 tables and 117 indexes which I defined for the same fields as in MS SQL.
> I converted the data using some SQL output from MS SQL server and inserted
> it with
On Mon, Sep 10, 2001 at 02:34:25PM +0200, Tille, Andreas wrote:
> On Mon, 10 Sep 2001 [EMAIL PROTECTED] wrote:
>
> > Use explain. Explain tells you the query plan of the optimizer.
> >
> > explain SELECT .;
> Thanks I just found the thread "Index usage question" and tried to make
> some profi
Joel Pang wrote:
>
> Hi Fraser,
>
> I've read your mail in postgresql web site that you've a procedure that will do bulk
>loading of records into database. I've been looking a utility just like the sql
>loader of Oracle for the Postgres database. I was wondering if you will share your
>proc
Hello,
my isp recently upgraded form postgreSQL 7.0 to 7.1. It went pretty well
but I just discovered that non-english characters are now in the database
as a question mark-- inserting non-english characters produces a ? as
well. Any idea what has gone wrong and what we need to do to fix this?
I recently upgraded to 7.1.3. I was experimenting with a script to
export data from FoxPro into an SQL file and multiple data files. The
SQL file creates the tables, indexes, foreign keys, etc, and calls the
COPY command to load the data from the appropriate data files.
It appears, and I cou
Hi all -
I have some questions about tuning the various kernel parameters
on FreeBSD. I've read Bruce's article a couple of times and the various
parts of the documentation, but I still have some questions and was hoping
people here could confirm/deny my assumptions.
The machine in quest
> my isp recently upgraded form postgreSQL 7.0 to 7.1. It went pretty well
> but I just discovered that non-english characters are now in the database
> as a question mark-- inserting non-english characters produces a ? as
> well. Any idea what has gone wrong and what we need to do to fix this?
> Forgott to say that I try to create a table named
> user.
>
> > Why is this so very commonly used word reserved?
> > Is that some kind of #define so you easily can recompile
> > PostgreSQL? If so, please guide me to the place. This is
> > truly annoying.
Rather than trying to tear apart a datab
Sorry Vince,
My mistake. I must have worded that badly.
What I mean is that some Agencies find it difficult to believe that we
would actually assist them in looking for candidates, especially
directly to a targeted audience, without demanding to be paid for the
effort.
Once they understand we'
On Mon, 10 Sep 2001, Justin Clift wrote:
> Sorry Vince,
>
> My mistake. I must have worded that badly.
>
> What I mean is that some Agencies find it difficult to believe that we
> would actually assist them in looking for candidates, especially
> directly to a targeted audience, without demandin
> my isp recently upgraded form postgreSQL 7.0 to 7.1. It went pretty well
> but I just discovered that non-english characters are now in the database
> as a question mark-- inserting non-english characters produces a ? as
> well. Any idea what has gone wrong and what we need to do to fix this?
The was corrupted in the process of the upgrade.
Is there some way to tell what the configuration options were when it was
installed? I am assuming by API you mean how am I accessing Postgres? JDBC.
Culley
>X-Apparently-To: [EMAIL PROTECTED] via web9605; 10 Sep 2001
>18:19:26 -0700 (PDT)
>
> As far as disks go. You cannot have too many spindles. But the number of
> spindles you have available depends on which pieces of postgres get split
> onto dedicated spindles.
But if you have enough RAM that the entire DB can be held in RAM, and
if the DB acess pattern is 90% read, 10% write
> The was corrupted in the process of the upgrade.
>
> Is there some way to tell what the configuration options were when it was
> installed?
pg_config --configure
> I am assuming by API you mean how am I accessing Postgres? JDBC.
7.1's JDBC driver has been slightly enhanced from 7.0 in the
On Monday 10 September 2001 18:52, Philip Hallstrom wrote:
> Hi all -
> I have some questions about tuning the various kernel parameters
> on FreeBSD. I've read Bruce's article a couple of times and the various
> parts of the documentation, but I still have some questions and was hoping
> p
Hi,
Is there a function like:
select md5() from
Thanks,
--
Feite Brekeveld
[EMAIL PROTECTED]
http://www.osiris-it.nl
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.ht
I am currently working on a patch to 7.2 that will allow data/indexes to
be in different locations. I am also looking at replacing the current
LOCATION code with a table driven (pg_locations) that will allow not
only the default data/indexes locations to be set but also each
table/index to have i
bpalmer <[EMAIL PROTECTED]> writes:
> I'm looking to make a DB server for a project I'm working on (using pgsql)
> and am wondering if people have suggestions?
>
> Thoughts:
>
> - Hardware: dual / quad Intel class
Athlon gives more bang for the buck - the dual Athlons are _really_
nice, and h
On Mon, Sep 10, 2001 at 11:40:27PM +0200, Feite Brekeveld wrote:
> Is there a function like:
>
> select md5() from
digest(field, 'md5')
If you want in hex:
encode(digest(field, 'md5'), 'hex')
Look into contrib/pgcrypto in PostgreSQL source.
--
marko
--
> > - Hardware: dual / quad Intel class
The ultimate would be an IBM S/390 mainframe running some distribution of
Linux S/390. I/O bandwidth on mainframe DASD is incredible, the memory is
robust and fast, and the CPU is trememdous.
The price is also trememdous.
--
Lamar Owen
WGCR Internet Ra
Here are two good articles, one on open source database, the other about
the Great Bridge closure, both from Computerworld:
http://www.computerworld.com/cwi/story/0,1199,NAV47_STO63629,00.html
http://www.computerworld.com/storyba/0,4125,NAV47_STO63600,00.html
--
Bruce
Daniel ?erud writes:
> Why is this so very commonly used word reserved?
Because SQL says so. More specifically, because USER is a special
function.
> Is that some kind of #define so you easily can recompile
> PostgreSQL?
Surely not.
> If so, please guide me to the place.
You can hack around
Yes see /contrig/pgcrypto.
> Hi,
>
> Is there a function like:
>
> select md5() from
>
> Thanks,
>
>
> --
> Feite Brekeveld
> [EMAIL PROTECTED]
> http://www.osiris-it.nl
>
>
>
>
> ---(end of broadcast)---
> TIP 5: Have you checked our
> I'd probably go for a 3ware RAID instead... IDE disks are so much
> cheaper nowadays than SCSI, and the premium isn't really justifiable
> anymore.
Having used IDE and SCSI disks, when I'm serious about performance, IDE
doesn't even enter my mind. Also, over on the XFS list, there are a few
> I'm not sure how much a 2+ way system will help. Most of the db work
> will be done in one long serialized processes and those can't be spread
> out over multiple processors (with current day postgresql).
That's assuming that only one query will ever be executed at once. As a
new backend is
COPY expects NULL to be represented by "\N" by default.
Probably easiest to explicitly specify on the command line what you want
COPY to recognize as a NULL: "copy table from wherever with null as
'something';"
- Original Message -
From: "Dwayne Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
I second the RAM point. Not only is more better, you also need to configure
postgres to use it. You will need to take the average size of your
backends, the number of concurrent connections you expect and the amount of
RAM you want postgres to leave for the OS and all the other processes. This
My postgres build on MacOS X is failing:
cc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
-bundle -undefined suppress -bundle -undefined suppress fe-auth.o
fe-connect.o fe-exec.o fe-misc.o fe-print.o fe-lobj.o pqexpbuffer.o dllist.o
pqsignal.o -o libpq.so.2.1
/us
Hi,
You could try either of :
http://techdocs.postgresql.org/installguides.php#macosx
or
http://techdocs.postgresql.org/oresources.php#macosx
:-)
Regards and best wishes,
Justin Clift
Hunter Hillegas wrote:
>
> My postgres build on MacOS X is failing:
>
> cc -traditional-cpp -g -O2 -Wal
As you know, PostgreSQL has had a first-class infrastructure since we
started five years ago. This is all thanks to Marc Fournier who has
created and managed this infrastructure over the years.
Quality infrastructure is very important to an open-source project. It
prevents disruptions that can
I'm looking to make a DB server for a project I'm working on (using pgsql)
and am wondering if people have suggestions?
Thoughts:
- Hardware: dual / quad Intel class
- OS: Prolly FreeBSD (FFS is your friend (what with syncs and all) and it
can do multi proc support
- Disk: SCSI Raid 1+0
- Ram
On Mon, 10 Sep 2001, bpalmer wrote:
> - Hardware: dual / quad Intel class
Fairly easy to obtain. If all you want is a dual, you can use
desktop-class motherboards from such makers as Asus, Abit, and
IWill. If you're going for speed, stick to the DDR or SDRAM
capable boards.
> - Disk: SCSI R
COPY is the command used for bulk loading in PostgreSQL (check the "SQL
Commands" in the "Reference Manual" part of the docs).
COPY is not intelligent about interpreting varying data formats. Your
flexibility is limited to specifying the data delimiter and whatever string
you want to represent NU
43 matches
Mail list logo
