Looks like you have set the wrong host information in recovery.conf file or
there is a mistake in recovery.conf file. Please check your recovery.conf
file.
May be postgres should throw a correct message to the logs saying the host
information for replication is wrong or something meaningful to und
Based on the below error message it looks like the Database and tables
already exists. Please check the database.
When you do a regular pg_dump, it won't include all the roles. You to
include roles have should always use pg_dumpall -l ( you can read up more
using #man pg_dumpall).
Good luck!
~De
ng:
>
>show log_line_prefix;
>
> Looks like either your server hasn't reloaded the updated config file, or
> you edited the wrong config file.
>
> Lewis
>
>
> DM wrote:
>
>> Hi All,
>> I am not able to figure out how to change the logging
Hi All,
I am not able to figure out how to change the logging to a single line,
*My log file out puts*
LOG: duration: 0.492 ms
LOG: duration: 0.397 ms
LOG: duration: 0.097 ms
LOG: execute : select count(*) from v_mthly_demo_rollup
LOG: duration: 211.724 ms
LOG: duration: 0.499 ms
LOG: dur
All
How to Install compat-postgresql-libs-debuginfo on postgres 8.3.8 by
compiling the source code.
The way i have installed postgres is by compiling the postgres files.
Thanks
Deepak
Thank you guys for the answers.
On Tue, Apr 28, 2009 at 6:06 PM, Joshua D. Drake wrote:
>
> >
> > Ops team want to install postgres as (usr/local/bin) using RPM, and
> > want to keep the data directory under (/var/lib/data/pgsql) and they
> > say that we cannot have two versions at the same time
Hi All,
What is the best way to Install postgres database?
We have installed (2) versions of the postgres on th server using source
code (compiling and building) (/usr/local/pgsql/8.3.3/ and
/usr/local/pgsql/8.3.6/) and our data directory is (/mnt/data/pgsql/)
Our database size is more than 100GB.
, Apr 22, 2009 at 4:02 PM, Scott Marlowe wrote:
> On Wed, Apr 22, 2009 at 5:01 PM, Scott Marlowe
> wrote:
> > On Wed, Apr 22, 2009 at 4:19 PM, DM wrote:
> >> how to revoke multiple users permission from multiple tables at the same
> >> time?
> >> Or in simple
how to revoke multiple users permission from multiple tables at the same
time?
Or in simple is there a way to revoke multiple users grant access from
multiple tables under a schema.?
I use Revoke below command to execute on each table one by one.
revoke SELECT/ALL on testtable from user1;
Thanks
always defaults to -- /usr/local/pgsql/, Is there an RPM
that i can use where i can specify my installation directory path?
Thanks
DM
Hi All,
I installed postgres 8.3.5 yesterday, is there any configuration changes
that i have to make. (Buffer, cache)
Thanks
Deepak
Hi All,
I have a database of 10GB.
My Database Server has a RAM of 16GB
Is there a way that I can load all the database objects to memory?
Thanks for your time and taking a look at this question.
Thanks
Deepak
Hi All,
I am facing an error on executing the below command
dump name: pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing
databae name: pnqd_test
$pg_restore -U postgres -p 5433 -d pnqd_test
pg_dump_FcZ0.pnps_200903041201_1.2.1.0_base_testing
pg_restore: [archiver (db)] Error while PROCESSING
Thanks Steve for sharing this info.
Thanks
Deepak
On Mon, Mar 9, 2009 at 12:14 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> DM wrote:
>
>> Hi All,
>>
>> PST time changing tonight, I am not sure if this is going to affect the
>> database
&
On Sun, Mar 8, 2009 at 1:30 AM, DM wrote:
> > Thanks Scott for the quick response, do I need to do anything at my end
> to
> > solve this issue.
> >
> > People access our servers from Pacific, Central, Mountain and East Time
> > zones.
> > Please let me know
Sun, Mar 8, 2009 at 12:23 AM, Scott Marlowe wrote:
> On Sun, Mar 8, 2009 at 12:58 AM, DM wrote:
> > Hi All,
> > PST time changing tonight, I am not sure if this is going to affect the
> > database.
> > Please throw some light if the time change affect on our production
Hi All,
PST time changing tonight, I am not sure if this is going to affect the
database.
Please throw some light if the time change affect on our production system.
Briefly - We have 2 production database servers with postgresql 8.3.3 and
pgpool 2.1 version running.
Here is the configuration de
Hi All,
I have installed Postgres 8.3.3 and Pgpool 2.2RC2 on two machines and* Both
*servers have the identical copy of the database running.
I have started postgres server on both machines and I have started pgpool on
both machines.
But for some reasons i am not able to connect to database throu
First make sure you stop the 8.3.3 / 8.3.6 server and then start 8.3.6
server and point the data path to 8.3.3 data path.
/usr/postgres/8.3.3/bin/pg_ctl -D /usr/postgres/8.3.3/data/pgsql8.3.3 stop
/usr/postgres/8.3.6/bin/postgres -i -D /usr/postgres/8.3.3/data/pgsql8.3.3
>logfile 2>&1 &
Enjoy
Hi Ray,
You need
ncurses-dev, libedit, libedit-dev, libreadline-dev, libreadline
On Fedora, I Installed ncurses and libed-dev or so and i was able to
compile.
Thanks
Deepak Murthy
On Tue, Feb 17, 2009 at 1:01 PM, Joshua D. Drake wrote:
> Isabella Ghiurea wrote:
>
>> Hi Ray,
>>
>> Thank you ,
20 matches
Mail list logo
