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:
http://www.postgresql.o
Zitat von bilal ghayyad :
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 Signature
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 vers
bilal ghayyad 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 might even show some
Mine is Fedora 10, how it will be?
regards
bilal
--- On Thu, 3/31/11, Devrim GÜNDÜZ wrote:
> From: Devrim GÜNDÜZ
> Subject: Re: [ADMIN] ls /var/lib/pgsql/data nothing
> To: "bilal ghayyad"
> Cc: pgsql-admin@postgresql.org
> Date: Thursday, March 31, 2011, 7:27 AM
> On Thu, 2011-03-31 at 04:17
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: devrim~P
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 c
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 wrote:
> From: Devrim GÜNDÜZ
> Subject: Re: [ADMIN] ls /var/lib/pgsql/data nothing
> To: "bilal ghayyad"
> Cc:
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
PostgreS
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
tablesp
On Thu, Mar 31, 2011 at 7:11 PM, Tony Capobianco 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 corrupt index?
>
Yes,
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 conn
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 p
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, the
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 applic
* 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 wrote:
> * Selva manickaraja (mavle...@gmail.com) wrote:
> > Any clue as to what could be the problem?
>
> Can you pr
* 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.a
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, Steph
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),
archive_tim
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 V
* 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 parame
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 compres
On Fri, Apr 1, 2011 at 10:35 AM, Stephen Frost wrote:
> * 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 ch
27 matches
Mail list logo
