Hi,
fd 0 is usually stdin, unless the program disconnects stdin.
Maybe pg_restore is waiting for input, perhaps a password?
certainly shouldn't be - the table where the problem happens is no
different to any of the others, but I will try doing just that table
later today and see if that makes
Hi,
Im currently on red hat 7.3
running postgres. Everything is running fine. Obviously, Im going
to have to upgrade to RHEL 3 in order to receive updates, etc. Does
anyone know of any problems with postgres running on RHEL 2.1 or RHEL
3?
We run PostgreSQL on a RHEL 2.1
Apologies for sending HTML mail to the list.
Here is a decent version of my message:
Hi,
Im currently on red hat 7.3 running postgres. Everything is running fine.
Obviously, Im going to have to upgrade
I want to do auto backup for pg with cronjob.
The problem is it equesting for password.
I have tried with pgpass but still
it does not work. I created the pgpass as per below:
echo
your_host:5432:your_user:your_db:your_pass ~/.pgpass
bash$ chmod 600 ~/.pgpass
My cronjob entry is
When I issue the command it is asking for passwd which I cannot used for
cronjob to run at midnight.
Execute the task as user postgres (crontab for postgres, not root) and
modify pg_hba.conf to permit access in trust mode (without asking for
password)
e.g : local all postgres
Hi,
Trying to restore a table that has about 80 million records. The database was
dumped and restored according to the following procedure:
1) dump the db, data only
time /usr/local/pgsql/bin/pg_dump -abf ./pgsql.7.4.rc1.pgdump.Z --format=c
--compress=6 -U postgres testdb
2) create db schema
--- ow [EMAIL PROTECTED] wrote:
Hi,
Trying to restore a table that has about 80 million records. The database was
[...]
I meant pg7.4.rc2, of course. Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
Hi,
I have found, on 7.3.4, a _massive_ performance difference on restoring
without indices - on a 25million row table from 8 hours down to 1
hour!
I've found the best way is to do this... (there may be a script
somewhere that automates this)
- do a --schema-only restore to create the tables
On Tue, Nov 11, 2003 at 07:29:42PM +0100, Gaetano Mendola wrote:
Seems that solaris is the worst choice for run Postgres.
Am I completely wrong ?
Windows is worse ;-)
A
--
Andrew Sullivan 204-4141 Yonge Street
Afilias CanadaToronto,
On Tue, Nov 11, 2003 at 01:52:26PM -0700, scott.marlowe wrote:
I thought .org and .info were being run on postgresql/solaris?
They are. I'd happily dump the Solaris use overboard, however, if it
weren't for all the nifty hardware support it give us. It is
dog-slow for handling large numbers
Danielle Cossette wrote:
Good morning,
Could you please let me know if Postgres 7.1.3 will run on Solaris 9.
If it does, are you aware of any issues.
I've run 7.1, 7.2 and 7.3 on Solaris 8 x86 and Solaris 9 x86. 7.1
install, config, run was nearly 100% hands-off. 7.3 takes setting
Stephan Szabo wrote:
On Tue, 11 Nov 2003, pginfo wrote:
It is possible to be one not closed transaction, but in this case nobody will
be
able to modify this table (tables) and
the system will stop to respond. The paradox is that the system works well
without
Not
Hi all,
Please help, I keep receiving this error message, see below, and I don't know how to go around this problem,can anyone help.
Regards
Denis
tar: Removing leading `/' from member names
tar (child): /dev/st0: Wrote only 0 of 10240 bytes
tar (child): Error is not recoverable: exiting now
[EMAIL PROTECTED] (Shane Wright) writes:
I have found, on 7.3.4, a _massive_ performance difference on
restoring without indices - on a 25million row table from 8 hours down
to 1 hour!
I've found the best way is to do this... (there may be a script
somewhere that automates this)
- do a
Hi,
Is there a way to take the database offline to keep users out?
Is there a way to take the database offline but still allowing pg_restore to
run against it?
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
On Wed, Nov 12, 2003 at 12:07:23 -0800,
ow [EMAIL PROTECTED] wrote:
Hi,
Is there a way to take the database offline to keep users out?
Is there a way to take the database offline but still allowing pg_restore to
run against it?
You could shut the database down, change pg_hba.conf to only
On Wed, 12 Nov 2003, ow wrote:
Hi,
Is there a way to take the database offline to keep users out?
Is there a way to take the database offline but still allowing pg_restore to
run against it?
Yes, as of 7.3 you can create entries in pg_hba.conf that control who can
connect to what
Glenn Wiorek [EMAIL PROTECTED] writes:
I just finished compiling 7.4RC2 on Solaris 8 and ran the regression tests =
(make check). The last test out of 93 (stats) failed. Is this of concern?=
It means the stats collector is failing, probably because it's unable to
set up the self-connected UDP
After having initdb'd and started the server (gmake check said it passed all
93 tests), and doing a make; make install in pgcrypto, I tried creating the
pgcrytpo functions with
# psql -d template1 -f pgcrypto.sql
This produced a series of errors as follows:
2003-11-12 16:56:14.287480500 [9781]
Murthy Kambhampaty [EMAIL PROTECTED] writes:
# psql -d template1 -f pgcrypto.sql
2003-11-12 16:56:14.293247500 [9781] ERROR: could not load library
/usr/local/pgsql-7.4/lib/pgcrypto.so:
/usr/local/pgsql-7.4/lib/pgcrypto.so: undefined symbol: px_find_digest
Works for me (at least, the
On Wed, 2003-11-12 at 14:14, Murthy Kambhampaty wrote:
Is this from user error or is pgcrypto not working yet in RC2?
It works for me (x86, redhat 7.3, linux 2.4.18). I did make install in pgcrypto/, then:
CREATE FUNCTION digest (text, text) RETURNS bytea
AS 'pgcrypto', 'pg_digest'
Is there an easy way to copy all DBs and users on a server to another
server?
I need to get an exact duplicate.
Thanks in avance!
---
Josh Trefethen
Exciteworks, Inc
http://exciteworks.com
---(end of broadcast)---
TIP 6: Have you searched our
I have tried with pgpass but still it do
es not work. I created the pgpass as per below:
Version? ~/.pgpass is supported since 7.3. Two more solutions are:
1) Set PGPASSWORD variable to avoid pg_dump asking for password
2) Set connection as trust in pg_hba.conf
regards,
bhuvaneswaran
On Thu, 2003-11-13 at 07:47, exciteworks hosting wrote:
Is there an easy way to copy all DBs and users on a server to another
server?
pg_dumpall is a good partner. If i am correct, you can also copy the
entire data directory, provided if both versions are same.
regards,
bhuvaneswaran
scott.marlowe wrote:
On Wed, 12 Nov 2003, ow wrote:
Hi,
Is there a way to take the database offline to keep users out?
Is there a way to take the database offline but still allowing pg_restore to
run against it?
Yes, as of 7.3 you can create entries in pg_hba.conf that control who
25 matches
Mail list logo
