Scott Marlowe wrote:
On 8/20/07, luis perruca [EMAIL PROTECTED] wrote:
Hi All: I'm From Spain and I'll try to write in english as best as possible:
Your english my spanish, so please don't worry.
I'm new in the list, and I have a serious problem: I am novice with
Postgresql and
Louis, first try to start Your PostgreSQL engine with a hand from
command line window like this:
/usr/local/pgsql/bin/postmaster -D /home/postgres/data/psql
...and look, what's will be happen.
Of course, these /usr/local/pgsql/bin/ shold be Your path do
postmaster binary and
/cgi-bin/foclick.cgi?mid=6850d=20070821
---(end of
broadcast)---TIP 1: if posting/reading through
Usenet, please send an appropriate subscribe-nomail command to
[EMAIL PROTECTED] so that your message can get through to the
mailing list
Hi Ben!
Thanks for your answer! It hits the spot.
Peter
Am 17.08.2007 um 19:28 schrieb Ben Kim:
I want to know whether there exist the possibility to create a
user who has the permission to create users with preset limited
permissions.
In detail:
I do not want that the admin user (a
Hello all,
I am new to POSTGRESQL and I am trying to dump and load a database...using
the steps below I get DUP errors when trying to LOAD the file into an
existing database...
Do I have to DROP \ recreate and load the target database (this is what I
currently do)? is there a way to just do an
I need some guidance.
I need to have an after insert trigger execute on a specific table and
export the results of query to a file on the database file system. Is this
possible to do from a trigger? If so, how can I accomplish this? I am
drawing a blank on how to export the results of the
On Tue, Aug 21, 2007 at 9:50 AM, in message [EMAIL PROTECTED],
smiley2211 [EMAIL PROTECTED] wrote:
Do I have to DROP \ recreate and load the target database (this is what I
currently do)? is there a way to just do an IN PLACE load like in other
RDBMS environments???
pg_dump proddb |
On 8/21/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi Medi,
Last night, I wrote a function which perfoms a subset of queries and returns
the results of a temporary table. It's more fast than I believe and that's
ok to me.
There is a prolem : It works too fine. I'm afraid of Murphy's law.
On 8/21/07, Chris Hoover [EMAIL PROTECTED] wrote:
I need some guidance.
I need to have an after insert trigger execute on a specific table and
export the results of query to a file on the database file system. Is this
possible to do from a trigger? If so, how can I accomplish this? I am
On 8/21/07, Kevin Grittner [EMAIL PROTECTED] wrote:
On Tue, Aug 21, 2007 at 9:50 AM, in message [EMAIL PROTECTED],
smiley2211 [EMAIL PROTECTED] wrote:
Do I have to DROP \ recreate and load the target database (this is what I
currently do)? is there a way to just do an IN PLACE load like
Many thanks, Tom.
Tena
[EMAIL PROTECTED]
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Mon 8/20/2007 9:12 PM
To: Tena Sakai
Cc: Farhan Mughal; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] After adjusting checkpoint related entries in
postgresql.conf...
Tena
On 8/21/07, Scott Marlowe [EMAIL PROTECTED] wrote:
Yes. you need to use the copy command inside a function and use
security definer to say that the function runs as a superuser.
Ok, I thought from the documentation that copy could only extract entire
table or a specific column.
If I want
On 8/21/07, Chris Hoover [EMAIL PROTECTED] wrote:
On 8/21/07, Scott Marlowe [EMAIL PROTECTED] wrote:
Yes. you need to use the copy command inside a function and use
security definer to say that the function runs as a superuser.
Ok, I thought from the documentation that copy could only
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Medi Montaseri wrote:
Hi,
I have finally convinced my manager to consider the idea of migrating from
7.2 to 8.2. Obviously he needs an ROI (Return Of Investment) analysis (in a
technical sense).
So, I am wondering if anyone has worked on a
On 8/21/07, Medi Montaseri [EMAIL PROTECTED] wrote:
Hi,
I have finally convinced my manager to consider the idea of migrating from
7.2 to 8.2. Obviously he needs an ROI (Return Of Investment) analysis (in a
technical sense).
So, I am wondering if anyone has worked on a similar project where
What can I sayat least he is willing to listen now...thanks guys...
This is an excellent start...
Cheers everyone
Medi
On 8/21/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Medi Montaseri wrote:
Hi,
I have finally convinced my manager
Hi
How can i setup vacuum and database backup
from crontab on ubuntu.
The problem is that both programs ask password.
Could you send an example script.
Thanks
Pavel.
Looking for a deal? Find great
Jessica Richard wrote:
If the linux box has 8 CPU's, is there a way to configure for Postgres
to user 6 of them? how? Thanks!
Try that:
http://www.bullopensource.org/cpuset/
--
Andrzej Zawadzki
PLD
jid:[EMAIL PROTECTED]
---(end of broadcast)---
On 8/21/07, Bolotov Pavel [EMAIL PROTECTED] wrote:
Hi
How can i setup vacuum and database backup
from crontab on ubuntu.
The problem is that both programs ask password.
Could you send an example script.
All you need is a .pgpass file for the account running the backups.
(or trust for that
[EMAIL PROTECTED] (Medi Montaseri) writes:
I have finally convinced my manager to consider the idea of
migrating from 7.2 to 8.2. Obviously he needs an ROI (Return Of
Investment) analysis (in a technical sense). So, I am wondering if
anyone has worked on a similar project where you had to go
Thanks Chris,
I was actually just doing that and going down the list, picking fixes and
enhancements that are relevant to our productby the time I got to
7.3...I came almost the same conclusion that I should just print (all of)
them and drop them on his desk..:-)
This is good, I thank
I'm using cygwin on WinXP and upgrading from 8.1 to 8.2.4.
Under 8.1, I ran a full backup and stored that as GZIP file.
Under 8.2, I tried to restore using the command:
gunzip -c backup81.gz | pg_restore -v -O -d mydb
This returned an error: pg_restore: [archiver] did not find magic
string
Hi Everybody,
According to section 23.3.2 of 8.2.4 manual:
Also, some versions of GNU tar consider it
an error if a file is changed while tar is
copying it. There does not seem to be any
very convenient way to distinguish this
error from other types of errors, other
than manual
On Tue, Aug 21, 2007 at 7:23 PM, in message [EMAIL PROTECTED],
David Wall [EMAIL PROTECTED] wrote:
I'm using cygwin on WinXP
gunzip -c backup81.gz | pg_restore -v -O -d mydb
This returned an error: pg_restore: [archiver] did not find magic
string in file header
Out of curiosity,
Yes it does the same thing:
$ gunzip mydb.dump.20070819.gz | pg_restore -v -O -d mydb
pg_restore: [archiver] did not find magic string in file header
Most odd since it seems to work just fine if gunzip first and then use:
pg_restore -v -O -d mydb mydb.dump.20070819
David
Kevin Grittner
On Tue, Aug 21, 2007 at 7:28 PM, in message
[EMAIL PROTECTED], Tena Sakai
[EMAIL PROTECTED] wrote:
On my linux machine, gnu tar is the tar. Does
anybody have a suggestion as to where I can go
to get a tar that is not gnu?
Have you considered using cpio instead?
Tena Sakai wrote:
Hi Everybody,
According to section 23.3.2 of 8.2.4 manual:
Also, some versions of GNU tar consider it
an error if a file is changed while tar is
copying it. There does not seem to be any
very convenient way to distinguish this
error from other types of
Hi Kevin,
Yes, I have, but I am much more familiar with tar.
I think I will go with the latest gnu tar (v 1.18)
which is suggested by Bruce. I will play with it
tomorrow and see how it goes.
Thanks.
Tena
[EMAIL PROTECTED]
-Original Message-
From: Kevin Grittner [mailto:[EMAIL
28 matches
Mail list logo