9.6, which is not compatible with this version 9.4.9.
stopped waiting
pg_ctl: could not start server
Examine the log output.
Is it possible to upgrade Postgres 9.4.9 to 9.6 with pg_upgrade option or I
need to do it through pg_dump only? Any help would be appreciated.
Thanks,
Ashish Chauhan
Please shutdown that postmaster and try again.
Failure, exiting
Thanks,
Ashish Chauhan
SION -
assumed '_PGPOOL2_VERSION' in /var/www/html/pgpoolAdmin-3.5.3/bootstrap.php on
line 33, referer:
http://xx.xx.xx.xx/pgpoolAdmin-3.5.3/install/checkDirectory.php";
Thanks,
Ashish Chauhan
application server one by one from Load balancer and
point it to PgPool which will not affect our application.
Could you pls send me steps how to install PgPool without PgPoolAdmin?
Thanks,
Ashish
From: Venkata B Nagothi [mailto:nag1...@gmail.com]
Sent: Wednesday, September 07, 2016 5:46 PM, 17:46
To
without any downtime?
http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2_3.3/
http://www.wirabumisoftware.com/en/openbravo-developer-guide/postgresqldevtutorial/25-pgsqlid/82-install-pgpool2
Thanks,
Ashish Chauhan
behind.
SELECT pg_last_xlog_receive_location() receive, pg_last_xlog_replay_location()
replay, now() - pg_last_xact_replay_timestamp() AS replication_delay,
(extract(epoch FROM now()) - extract(epoch FROM
pg_last_xact_replay_timestamp()))::int lag
Thanks for your help!
Thanks,
Ashish Chauhan
:01.612415 | -2
Thanks,
Ashish
From: Venkata Balaji N [mailto:nag1...@gmail.com]
Sent: Sunday, February 21, 2016 2:14 AM, 2:14
To: Ashish Chauhan
Cc: Andreas Kretschmer; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Live steraming replication setup issue!
On Fri, Feb 19, 2016 at 6:24 PM
server will poll the trigger file path periodically and start as a
# primary server when it's found.
#
trigger_file = '/data/main/primary.trigger'
Thanks,
Ashish
-Original Message-
From: Andreas Kretschmer [mailto:andr...@a-kretschmer.de]
Sent: Thursday, February 18, 201
? archive_mode = on and
archive_command = some command?
Biggest issue is, replication running between master and slave and I need to
build DR from slave server.
Thanks,
Ashish
From: Venkata Balaji N [mailto:nag1...@gmail.com]
Sent: Thursday, February 18, 2016 3:45 PM, 15:45
To: Ashish Chauhan
Cc
ster server are running? I cannot stop master server. Can someone
please guide with steps?
Thanks for your help in advance.
Thanks
-Ashish
wow! http://cochesclasicosparabodas.com/cnn.com_world.html
mjfamywelicjnyqepohu
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Tomas,
Thanks. Increasing the wal_keep_segments to 4000 did the trick.
I will set up WAL archive as well.
Thanks again.
Ashish.
On Sat, Nov 19, 2011 at 5:59 PM, Tomas Vondra wrote:
> Hi,
>
> On 19 Listopad 2011, 10:44, Ashish Gupta wrote:
> > I searched on various forum
various forums, where people encountered similar error,
however in all such issues WAL file existed on Master. In this case Master
is not retaining the WAL file required by the Slave.
I am unable to understand as to why Master is not retaining the WAL files.
Any pointer/suggestions would be helpful.
Thanks for attention.
Ashish
isting row?
>>
>
> You can simply send the UPDATE, if nothing was updated, it's safe to
> send the INSERT
>
> Regards
> Thomas
>
>
>
something on the line of
http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html
*Example 38-2. Exceptions with UPDATE/INSERT*
--
With Regards
Ashish Karalkar
e is an example:
http://pgsql.privatepaste.com/74d558e05f
Any help would be much /appreciated./
--
With Regards
Ashish Karalkar
way to start?
>
> Thanks,
> Dipti
http://www.postgresql.org/docs/8.4/interactive/user-manag.html
this will be a good starting point
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pd.objoid
AND pc.relname=ic.table_name
AND ic.ordinal_position=pd.objsubid
AND pc.relnamespace=pn.oid
AND pn.nspname in ('public')
ORDER BY pn.nspname,pc.relname,ic.ordinal_position;
With Regards
--Ashish Karalkar
-
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
Simon Riggs wrote:
On Wed, 2009-03-18 at 11:19 +0530, Ashish Karalkar wrote:
Postgres Plus does support Linux and it includes all the PostgreSQL
features as well as have many other additional useful features.One of
which is its dyna tune module.
You can check through the webpage
http
useful features.One of
which is its dyna tune module.
You can check through the webpage
http://www.enterprisedb.com/products/postgres_plus.do for detail
additional features.
I am using it on Linux and so far haven't faced any problem :-)
With Regards
--Ashish
-
Sent via pgsql-general ma
Regards
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
transaction.
With Regards
Ashish Karalkar
EnterpriseDB
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Ashish Karalkar wrote:
Hello list,
I was wondering is there any postgresql template for cacti to monitor
PostgreSQL server.
can anybody plz point me to the same?
Thanks in advance
--Ashish
That worked from google,
sorry for making noise...
http://forums.cacti.net/about23300.html
Hello list,
I was wondering is there any postgresql template for cacti to monitor
PostgreSQL server.
can anybody plz point me to the same?
Thanks in advance
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Siddharth
Take a look at
http://www.westnet.com/~gsmith/content/postgresql/InsideBufferCache.pdf
http://postgresql.mirrors-r-us.net/files/documentation/books/aw_pgsql/hw_performance/node3.html
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
,
Najios
Do you have listen_adress in postgresql.conf set properly i.e. to the
listen to the adress from where connection is comming or just * to
listen to all adresses.
this postgresql.conf file is in PG_DDIR
With Regards
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ö,
Torsten.
If I understood you correctly you might get help from following:
http://pgfouine.projects.postgresql.org/
With Regards
Ashish Karalkar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
. Tyagi
Sphere Networks
-Original Message-
From: Ashish Karalkar [mailto:ashis...@synechron.com]
Sent: Wednesday, February 25, 2009 4:38 PM
To: Shahbaz A. Tyagi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore DB
Shahbaz A. Tyagi wrote:
Hi,
We are using Postgres 8.3
.
Shabz
What is the Error?
There are many ways to restore a backup and depends on how you took the
backup.
Plz lets us know how u took the backup and what O/S you r using
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
.
Shabz
What is the Error?
There are many ways to restore a backup and depends on how you took the
backup.
Plz lets us know how u took the backup and what O/S you r using
--Ashish
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
Kusuma Pabba wrote:
when creating tables,
in my sql i have used create table
CREATE TABLE `users` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(50) NOT NULL,
`first_name` varchar(50) default NULL,
`middle_name` varchar(50) default NULL,
`last_name` varchar(50) default NUL
Abdul Rahman wrote:
Hi all,
Can any body tell me about tool for PostgreSQL load testing preferably
freeware.
Regards,
Abdul Rehman.
I am not sure its a freeware or not but looks promising
http://bristlecone.continuent.org/HomePage
--Ashish
--
Sent via pgsql-general mailing list (pgsql
Ashish Karalkar wrote:
Abdul Rahman wrote:
Hi all,
Can any body tell me about tool for PostgreSQL load testing
preferably freeware.
Regards,
Abdul Rehman.
I am not sure its a freeware or not but looks promising
http://bristlecone.continuent.org/HomePage
--Ashish
And ofcourse the
,
Ashish Sharma
Core Database Systems
HYPERLINK "http://www.coredbsystems.com"http://www.coredbsystems.com
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.5/1356 - Release Date: 4/2/2008
4:14 PM
what if the psql clients are different (local: 8.1.5 remote:8.2.6)?
>
> Thanks
> Victor
>
>
from remote m/c
psql -h some_hostname -c "copy temp to stdout" -Upostgres postgres >
temp.txt
Will create temp
gt;
Install psql client on that other m/c and fire command psql -c "copy
" from there :)
ofcourse with proper pg_hba.conf
With regards
Ashish
===
sms START NETCORE to 575758 to get updates on Netcore's enterpr
ot; does not allow me to dump from a
> SQL SELECT query which is what I wanna do.
>
>
May be selective COPY will help you.
http://www.postgresql.org/docs/8.3/interactive/sql-copy.html
With regards
Ashish
===
sms START NETCORE to
Hello List membersI have just upgraded the PostgreSQL server from 8.2.4 to 8.3 on Suse 10.3 64 bit.While inspecting the log i see this errorERROR: shared buffer hash table corruptedCan anybody please help me in getting into details of it?With regardsAshish...
Unlimited freedom, unlimited s
Hello list members,I hav a table with 140M rows. While I am trying to select the count from the tableI am getting following errorERROR: shared buffer hash table corruptedCan anybody please suggest me wht had gone wrong and how to fix it?PostgreSQL 8.2.4OS:Suse 10.3With RegardsAshish...
Sa
Thanks for the replayI think you missed on second detail mail :For more details:I have two tables master,child.with child having fk to master.Now
that master table contains 4M rows . while I update them (Master table)
the inserts are going into waiting mode on child table.Update
acquired row exclu
--- On Wed, 9/1/08, Ashish Karalkar <[EMAIL PROTECTED]> wrote:From: Ashish Karalkar <[EMAIL PROTECTED]>Subject: [GENERAL] Insert waiting for update?To: "pggeneral" Cc: [EMAIL PROTECTED]Date: Wednesday, 9 January, 2008, 4:29 PMDear list members,I am having table with 4M rows
Dear list members,I am having table with 4M rows.I am trying to update all these rows with statementupdate mytable set mycolumn=0;At the same time there are insert happening on the table.but all these insert are in waiting mode. does update is locking the table for insert?does insert and update con
2 postgres postgres 4.0K 2008-01-07 15:09 archive_status
drwxr-xr-x 3 postgres postgres 4.0K 2008-01-07 15:09 .
-rw--- 1 postgres postgres 16M 2008-01-07 15:15 000100170013
With Regards
Ashish
-
Chat on a cool, new interface. No
Richard Huxton <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
> query which was taking seconds on the join of these two table
> suddenly started taking 20/25 min
Show the EXPLAIN ANALYSE of your problem query and someone will be able
to tell you why.
Here is the output from exp
Thanks Richard for your replay,
here is the output..
Richard Huxton <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
>
> Richard Huxton wrote: Ashish Karalkar wrote:
>> query which was taking seconds on the join of these two table
>> suddenly started taking 20/25 m
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 11:44:58
+0000 mailte Ashish Karalkar folgendes:
> Hi,
> I am having PostgreSQL 8.2.4 on Suse 10.3
>
> Server is not using the index insted it chooses to take seq scan path. table
> is
> h
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 12:25:20
+0000 mailte Ashish Karalkar folgendes:
> > here is the output from planner:
> > Nested Loop IN Join (cost=0.00..5030217.97 rows=2 width=106)
> > -> Seq Scan on sm
Alvaro Herrera <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
> Thanks for your answer actually that was the part of full query here is the
> actuall plan
I think you are confusing this for "here is a completely different plan
for a completely different query that
Alvaro Herrera <[EMAIL PROTECTED]> wrote: Ashish Karalkar wrote:
> Thanks for your answer actually that was the part of full query here is the
> actuall plan
I think you are confusing this for "here is a completely different plan
for a completely different query that
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 12.12.2007, um 12:44:09
+0000 mailte Ashish Karalkar folgendes:
> > Do you have an index on "mobile"? Can you show us the table definition
> > and the output from EXPLAIN ANALYSE?
>
0:00'::timestamp without time
zone) AND (createddate < '2007-12-11 21:00:00'::timestamp without time zone)
AND ((keyword)::text = 'CRI'::text))
column deliveryid has an index over it in sms_new table.
can anybody please guide to force the u
count of all user group by type_id who are subscribed to
only one type e.g
type_id count
12
6 1
any suggestions?
Thanks in advance
With regards
Ashish
-
Unlimited freedom, unlimited storage. Get it now
"A. Kretschmer" <[EMAIL PROTECTED]> wrote: am Wed, dem 05.12.2007, um 10:24:04
+0000 mailte Ashish Karalkar folgendes:
> Hello List member,
>
> Iha a table containing two columns x and y . for single value of x there are
> multiple values in y e.g
>
> X
PQR:XYZ
3XYZ
4LMN
Any help will be really helpful
Thanks in advance
With Regards
Ashish
-
Why delete messages? Unlimited storage is just a click away.
Thanks Simon for your replay,
Yes I have followed the same instruction givn on the link, still it is
happining , should i ignore this message too?
With Regards
Ashish
Simon Riggs <[EMAIL PROTECTED]> wrote: On Wed, 2007-11-28 at 06:05 +0000,
Ashish Karalkar wrote:
> I have PostgreSQL
r filer 57 not found in
archive area.
With Regards
Ashish...
-
Explore your hobbies and interests. Click here to begin.
58
,00010059 in it.
Now from log it can be seen warning for WAL 00010057
Can anybody please explain me wht is going wrong?
JUST for note:recover was complete.
Thanks in advance
With regards
Ashish...
-
Find a mall, hotel or ATM in any part of India. Click here.
Hello All,
I am getting following error when trying to create new database.
createdb: database creation failed: ERROR: could not create directory
"base/1923827": No space left on device
can anybody please tell me what is going wrong.
Thanks in advance.
With regards
Ashish
sertion
In MySQL, I can insert multiple rows like this:
insert into cars values(5, "toyota"),(5,"ford"), etc.
How can I do something similiar in PostgreSQL?
insert into cars (id,name) values (1,'toyota'),(2,'ford');
With Regards
Ashish
poolAdmin-1.0.0/libs/Smarty.class.php on line 1258
Can anybody suggest what is going wrong.
I have physicaly verifies the file
'templates_c/%%6A^6A5^6A537DD8%%login.tpl.php' is there and also the
permission is 777 to user apche .
Thanks in advance
with regards
Ashish
- Original Message -
From: Ashish Karalkar
To: Devrim GÜNDÜZ
Sent: Tuesday, September 25, 2007 4:30 PM
Subject: Re: [GENERAL] PgpoolAdmin installation
I got the answer for the same and is sloved it is just a file which gives
information about the php installations.
I have verified
It is
confirmed that the function of php_mstring and php_pgsql is effective.
a.. "Multibyte Support" is "enabled".
b.. "PostgreSQL Support" is "enabled". "
But I dont see any phpinfo.php file in the install directory.
What may be the reason?
With Re
point me
to the link?
With Regards
Ashish...
As per as I think this is not bug,
in first case
when u update the first row
In first case:
M1= 1+1 =2 conflict with the second row.
in second case:
M1=3+1=4 no conflict with second row
I hope this will help.
With reagrds
Ashish
- Original Message -
From: Anoo Sivadasan
Hello All,
I am having a table with 5 columns.
I want to add another column by altering the table at 2nd position constraint
is that I can not drop and recreate the table as column ordering is of
importance.
Is there anyway to do so.
Thanks in advance.
With regards
Ashish...
Hello All,
I am having a table with 5 columns.
I want to add another column by altering the table at 2nd position
constraint is that I can not drop and recreate the table as column ordering
is of importance.
Is there anyway to do so.
Thanks in advance.
With regards
Ashish
- Original Message -
From: "Albe Laurenz" <[EMAIL PROTECTED]>
To: "Ashish Karalkar *EXTERN*" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, September 03, 2007 4:54 PM
Subject: RE: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff
Ashish K
- Original Message -
From: "Ashish Karalkar" <[EMAIL PROTECTED]>
To: "Albe Laurenz" <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2007 4:09 PM
Subject: Re: [GENERAL] invalid byte sequence for encoding "UTF8": 0xff
- Original M
Hello All,
I have a data script which runs fine from PgAdmin SQL Editor,but when I run
this from command prompt I get following error:
test=# \i /usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql
psql:/usr/local/pgsql/qsweb1/QSWEB_100_4_Default_Data.sql:1: ERROR: invalid byt
e sequence fo
Hello All,
I want to export data from PostgreSQL tables to MS Excel.
Is there any way?
Thanks in advance...
With Regrads
Ashish...
advance
With regards
Ashish...
take a look at dblink in contrib module
With Regards
Ashish...
- Original Message -
From: "Phoenix Kiula" <[EMAIL PROTECTED]>
To: "Postgres General"
Sent: Thursday, August 16, 2007 6:18 PM
Subject: [GENERAL] Accessing tables in other databases, throug
Hello All,
I am having following PostgreSQL & Linux version
PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
20041212 (Red Hat 3.4.3-9.EL4)
I am trying to create the backupfile using gunzip utility
pg_dump qsweb | gzip > /usr/local/backup/backup.gzBut when I run this comm
Hello All,
I am having PostgreSQL server 8.2.0 running on Redhat Linux .
I want to install PgAdmin GUI on the Linux Server.
can anybody please guide me to the appropriate documantation and the
prerequisite required for the same .
Thanks In Adavnce
With Reagrds
Ashish...
Hello all,
I want to take backup from one server and save it to another machine hard drive.
The backup will be taken through a shell script attached to a cron job.
something like:
pg_dump -d postgres -U postgres -f
is there any way?
With regards
ashish...
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 10, 2007 4:25 PM
Subject: Re: [GENERAL] pgpass.conf
Ashish Karalkar wrote:
Hello All,
I am trying tu run a script to create
- Original Message -
From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 10, 2007 3:51 PM
Subject: Re: [GENERAL] pgpass.conf
On 10/07/2007 08:47, Ashish Karalkar wrote:
Still the
contains:
localhost:5432 :*:postgres:mypass
localhost:5432:qsweb:qsweb:mypass1
Still the batch asks for the password.!!!
I am just not getting why its not reading password from pgpass file.
can anyone please figure out what is going wrong.
Thanks in Advance
Ashish...
Hello Stefan,
Recently I Have faced this problem and solved by .pgpass file approch
Take alook on
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html
With Regards
Ashish...
- Original Message -
From: "Stefan Zweig" <[EMAIL PROTECTED]>
To:
Sent: Tuesda
- Original Message - >
2007/7/2, Ashish Karalkar <[EMAIL PROTECTED]>:
Hello All,
I want to create a user through script and dont want user to assign
password
interactively, I want it to be assigned through some file or anything
else
some this like
createuser -P
TH='qsweb'"
The output is right till alter schema but then while setting the search
path it says NOTICE:schema "qsweb" does not exist.
can you suggest what is going wrong
Thanks in advance
Ashish...
- Original Message -
From: "A. Kret
Thanks for your replay Scott,
I am using just sql script
and there is no option like pwd with createuser command
With Regards
Ashish...
- Original Message -
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Sent
sult
OR
search path = ' "$user",xyz,public'
Same result
OR
search path = ' "$user",xyz'
Error:no schema has been selected to create in
Please suggest me the corrective action.
Thanks In advance
Ashish...
Hello All,
I want to create a user through script and dont want user to assign password
interactively, I want it to be assigned through some file or anything else
some this like
createuser -P * OR createuser -P
Is there any way?
Thanks in Advance
With Regards
Ashish...
Hello All,
I am trying to create a user and i dont understand why it is showing me any
massage even after giving parameter -e to the command.
command :
C:\Program Files\PostgreSQL\8.2\bin>createuser ashish -S -d -R -l -P -E -e -U
postgres
Enter password for new role:
Enter it ag
Thnkas Richard for your replay.
Actually ,I was looking for some setting in postgresql.conf file
Is there any one?
With Regards
Ashish
- Original Message -
From: "Richard Huxton" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>
Cc:
Sent:
Hello all,
I want to set Auto vaccunme in such a way that it will start in the Mid night
(12:00 A.M.)
Is there any way to do this except Cron Job for Linux
Thanks In advance
With Regards
ashish ...
ance
With regards
Ashish Karalkar
Hello All,
I have a long list of sql server queries that needs to me remoulded in to
postgres format
can anyone please suggest me any tool that will convert sqlserver query into
postgresql query except
SwisSQL - SQLOne Console 3.0
Thanks in advance
With regards
Ashish Karalkar
erstood is 512 KB+8192*number of buffers times the block +0.5M.B
But I am not getting the count of number of buffres.
In postgres.conf file there is size of shared buffer.
shared_buffer=24 MB.
can anybody point me to number of buffers if i have understood correctly
Thanks In advance.
With Regards
Ashish...
check under $PGHOME/data/pg_log directory.
Usually $PGHOME=/usr/local/pgsql if u have not changed this path during
installation
With Reagrds
Ashish...
- Original Message -
From: phillip
To: pgsql-general@postgresql.org
Sent: Thursday, June 07, 2007 2:21 PM
Subject
Hi All,
I want to create a user in Postgres Database. And I want to restrict that user
with some privileges. And also I want that user should be specific to
particular database.
He should not be able to do the following
1) Connect to any other database.
2) Connect to System da
Ok. That is on insert update delete part.
ant disadvantage on select part?
With Regards
Ashish...
- Original Message -
From: "Ron Johnson" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, May 09, 2007 2:18 PM
Subject: Re: [GENERAL] Views- Advantages and Disadvantages
Thanks All for your replies,
But then dont we have any disadvantage of using View???
With Reagrds
Ashish...
- Original Message -
From: "Andrej Ricnik-Bay" <[EMAIL PROTECTED]>
To: "Ron Johnson" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, May 09, 20
Thanks Brent for your replay,
What about the Disadvantages, Performance issues?
With Regards
Ashish...
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Postgres General"
Cc: "Ashish Karalkar" <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 20
multitable query,then
simple query against that view becomes a coplecated join, and it may take a
long time to complete
- Original Message -
From: "Andrej Ricnik-Bay" <[EMAIL PROTECTED]>
To: "Ashish Karalkar" <[EMAIL PROTECTED]>; "Postgres
General&q
Hello All,
Can anybody please point me to Advantages and Disadvantages of using view
With Regards
Ashish...
Can u tell us what are the role privilages granted to user "joe"
May be you r missing with the create database privilage to user joe
With Regards
Ashish
- Original Message -
From: "Kevin Murphy" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 04, 2007
l help
With Regards
Ashish
jasme <[EMAIL PROTECTED]> wrote:
hi,
i had made necessary change in the postgresql.conf for enabling WAL. How can
i know that WAL is working?
The configurations done in the postgr
files to higher segment numbers."
So there are 4/5 files. Now i want to switch to archiving mode.
which file name should be given in place of %f parameter of archive command
my command looks like this:
'cp -i /usr/local/pgsql/data/pg_xlog /mnt/server/archivedir/%f'
Thanks in advance
With Regards
Ashish...
/usr/local/pgsql/data/pg_xlog ?
is yes it is giving me following error
cp: omitting directory `/usr/local/pgsql/data/pg_xlog/
2)
which file name i should give in place of %f parameter as there are 5/6 files
already?
Thanks in Advance
With Regards
Ashish Karalkar
1 - 100 of 141 matches
Mail list logo
