Ravi,
To (attempt to) answer your questions:
1) does the custom archive format of pg_dump needs to be in a file (not
pipe) for the pg_restore to seek back forth ?
Not to my knowledge.
I suspect that the windows type command is adding extra header
information to the file before
Hi All;
I am root and when I do ls /var/lib/pgsql/data, I do not see anything.
Why?
I need to find the pg_h.conf file but not able.
Any help?
Regards
Bilal
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
Zitat von bilal ghayyad bilmar...@yahoo.com:
Hi All;
I am root and when I do ls /var/lib/pgsql/data, I do not see anything.
Why?
I need to find the pg_h.conf file but not able.
find / -name pg_hba.conf is your friend...
Regards
Andreas
smime.p7s
Description: S/MIME Cryptographic
On Thu, 2011-03-31 at 04:17 -0700, bilal ghayyad wrote:
I am root and when I do ls /var/lib/pgsql/data, I do not see
anything.
Why?
You need to initdb first. I think this is an RPM installation. If so,
service postgresql initdb
(or service postgresql-9.0 initdb , depending on the
bilal ghayyad bilmar...@yahoo.com writes:
Hi All;
I am root and when I do ls /var/lib/pgsql/data, I do not see anything.
Try the 'locate' command is it's on your system.
If you are able to connect to the DB, show data_directory;
Or, sudo su - postgres and see if $PGDATA is set.
ps -ef
Mine is Fedora 10, how it will be?
regards
bilal
--- On Thu, 3/31/11, Devrim GÜNDÜZ dev...@gunduz.org wrote:
From: Devrim GÜNDÜZ dev...@gunduz.org
Subject: Re: [ADMIN] ls /var/lib/pgsql/data nothing
To: bilal ghayyad bilmar...@yahoo.com
Cc: pgsql-admin@postgresql.org
Date: Thursday, March
On Thu, 2011-03-31 at 04:37 -0700, bilal ghayyad wrote:
Mine is Fedora 10, how it will be?
I already wrote what you need to do.
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community:
Hello,
He had a drive fail in an array and the spare kicked in to replace the
failed drive. However, when I query a specific table, I get the below
error:
ERROR: could not open file
pg_tblspc/16412/PG_9.0_201008051/16419/5875980.7 (target block
2968776487): No such file or directory
When I
Thanks a lot.
And how to make it started automatically when the machine booted? Without need
to type the command to start manuall?
Regards
Bilal
--- On Thu, 3/31/11, Devrim GÜNDÜZ dev...@gunduz.org wrote:
From: Devrim GÜNDÜZ dev...@gunduz.org
Subject: Re: [ADMIN] ls /var/lib/pgsql/data
On Thu, 2011-03-31 at 05:52 -0700, bilal ghayyad wrote:
And how to make it started automatically when the machine booted?
Without need to type the command to start manuall?
chkconfig postgresql on
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
We were able to determine through a few of our queries that an index was
corrupt. We did this through the process of elimination however. As a
result, I have two questions:
How can I determine that we have a corrupt index?
How can I determine which datafile (5875980.x) is related to which
On Thu, Mar 31, 2011 at 7:11 PM, Tony Capobianco tcapobia...@prospectiv.com
wrote:
We were able to determine through a few of our queries that an index was
corrupt. We did this through the process of elimination however. As a
result, I have two questions:
How can I determine that we have a
Hello Postgres Community,
Thank you guys very much for PostgreSQL. To me, its the best database
management system under the sun. I am setting up a new jail configuration on
FreeBSD with sockets and everything enabled. I can ping localhost fine. The
problem is that when I load a script that
Hi all,
We are using 9.03
Having shared_preload_libraries = 'auto_explain, pg_stat_statements' set in the
conf file causes some one starting up postgres to manually have to hit the
enter key. Suprresing this output with pg_ctl would be the best option, but I
don't it as an option(silent
On 03/31/2011 12:18 PM, babak badaei wrote:
Hello Postgres Community,
Thank you guys very much for PostgreSQL. To me, its the best database management system
under the sun. I am setting up a new jail configuration on FreeBSD with sockets and
everything enabled. I can ping localhost fine. The
All,
I have PG 9.03 setup with master slave native replication. Everything
seems to be fine. I have few question or concerns. Coming from MySql
background, so trying to setup my expectations for PG.
1. Very Large wal log size. Specially archiving WAL is bigger
pain. In our env,
Dear All,
We just migrated our system from Informix/GeneroDB to PostgreSQL 9.03. We
are monitoring the situation very closely.
Everything seems to be OK except our concern on the build up of WAL files.
You see, we cut off from the previous database around 3.30AM. After that we
directed our
* Selva manickaraja (mavle...@gmail.com) wrote:
Any clue as to what could be the problem?
Can you provide your postgresql.conf? Little hard to guess at possible
mistakes there without it..
Is it exactly once a minute?
Stephen
signature.asc
Description: Digital signature
Hi,
I'm attaching the file here. As of now it is 874 files within 3 hours.
Kindly assist.
Thanking in advance.
Regards,
Selvam
On Fri, Apr 1, 2011 at 8:42 AM, Stephen Frost sfr...@snowman.net wrote:
* Selva manickaraja (mavle...@gmail.com) wrote:
Any clue as to what could be the
* Selva manickaraja (mavle...@gmail.com) wrote:
I'm attaching the file here. As of now it is 874 files within 3 hours.
You have archive_timeout set to '5'. That means rotate a log file
every 5 seconds. You probably want to increase that.
Thanks
Stephen
signature.asc
If our check_timeout is 30 minutes, what would be an acceptable time limit
for archive_timeout?
Also since bulk loading/migration of large amount of data was done earlier,
do I need to run vacuum etc.
I will wait for your reply.
Thank you.
Regards,
Selvam
On Fri, Apr 1, 2011 at 9:03 AM,
Selva,
* Selva manickaraja (mavle...@gmail.com) wrote:
If our check_timeout is 30 minutes, what would be an acceptable time limit
for archive_timeout?
They're two different things. Checkpoints are about getting data
flushed out to the data files (so they're not just in the WALs),
Since the production database is running, I plan to do now is this
1. Set archive_timeout = 20m (Does the change require db restart to take
effect?)
2. Set autovacuum=on and track_count=on (Does the change require db restart
to take effect?)
Does that mean we are running autovacuum?
3. Run
* Selva manickaraja (mavle...@gmail.com) wrote:
1. Set archive_timeout = 20m (Does the change require db restart to take
effect?)
I *think* it can be changed with just a reload, but I'm not 100% sure.
Check your logs after doing the reload, it'll complain if it isn't able
to change that
Where you mentioned after the reload I suppose you meant restart right?
About compressing you mentioned iirc, but how do I use it? are there any
examples. I read about pg_compress before. Is that same?
The configuration file shows that autovacuum=on and track_count=on to be
commented out. That
* Selva manickaraja (mavle...@gmail.com) wrote:
Where you mentioned after the reload I suppose you meant restart right?
I'm not sure offhand if it requires a reload or a restart, that's why I
suggested doing a reload than then checking the logs to see if a restart
is required.
About
26 matches
Mail list logo