Tanks a lot to all...
Finally i got the solution... my postgres working fine on server...
-
Regards,
Suresh Hosur
--
View this message in context:
Hi every1 how are u all??? Members i am new in postgres and want to
work on pgrouting but i am facing some issue with it. Will u please help me???
I have loaded my line shapefile in pgadmin environment, which creates
a table name 'Route', but when i made a query 'Create View' at it, it
will
On 12/29/11 2:11 AM, saqi...@igis.nust.edu.pk wrote:
I am sending my problems with attachment please have a look at this..
please don't send attachments to email lists.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via
At 11:11 29/12/2011, you wrote:
Hi every1 how are u all??? Members i am new in postgres and want to
work on pgrouting but i am facing some issue with it. Will u please help me???
I have loaded my line shapefile in pgadmin environment, which creates
a table name 'Route', but when i made a query
On 12/29/2011 09:19 AM, Merlin Moncure wrote:
I'll pass, thanks for all your help guys. It's been a blast.
I did not suggest that. I suggested they *might* be happening. In
lieu of a reproducible test case (a couple of us took a stab at
creating one ourselves and could not come up with
On Thu, Dec 29, 2011 at 10:20 AM, Greg Donald gdon...@gmail.com wrote:
On Wed, Dec 28, 2011 at 4:57 PM, Tom Lane t...@sss.pgh.pa.us wrote:
SELECT pg_catalog.setval('cp_state_id_seq', 52, true);
SELECT pg_catalog.setval('cp_state_id_seq', 1, false);
These grep calls are showing just exactly
On 12/29/2011 08:13 AM, Greg Donald wrote:
On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaveradrian.kla...@gmail.com wrote:
What is the pg_dump command, with options, you are using?
My backup shell script contains:
/usr/bin/pg_dump cp | bzip2 $FILE
One possible issue that I see is the lack
On Wed, Dec 28, 2011 at 4:58 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
What is the pg_dump command, with options, you are using?
My backup shell script contains:
/usr/bin/pg_dump cp | bzip2 $FILE
--
Greg Donald
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On Thu, Dec 29, 2011 at 10:53 AM, Greg Donald gdon...@gmail.com wrote:
On Thu, Dec 29, 2011 at 10:27 AM, Merlin Moncure mmonc...@gmail.com wrote:
if you take a bzipped schema only dump (pg_dump -s), I'd be happy to
look it over and eliminate the 'operator error' class of issues that
Tom is
I am doing POC on Posgtresql replication. I am using latest version of
postgresql i.e. 9.1. There are multiple replication solutions avaliable in
the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide
in-built replication solutions (Streaming replication, Warm Standby and hot
karthikeyan kar...@relationalsolutions.com wrote:
Hi,
I am trying to increase size of the column which was/is part of the Primary.
Exiting table
CREATE TABLE test_dim_store
(
storek integer NOT NULL DEFAULT
nextval('dim_store_storek_seq1'::regclass),
retailerk character
On Thu, Dec 29, 2011 at 10:27 AM, Merlin Moncure mmonc...@gmail.com wrote:
if you take a bzipped schema only dump (pg_dump -s), I'd be happy to
look it over and eliminate the 'operator error' class of issues that
Tom is thinking might be happening. private mail is ok.
Operator error? Wow..
Hello fellow postgres users,
in my game using PostgreSQL 8.4.9 players can
purchase a VIP (very important person) status:
# \d pref_users;
Table public.pref_users
Column |Type | Modifiers
+-+---
On 12/29/11 3:11 AM, saqi...@igis.nust.edu.pk wrote:
Hi every1 how are u all??? Members i am new in postgres and want to
work on pgrouting but i am facing some issue with it. Will u please help
me???
I have loaded my line shapefile in pgadmin environment, which creates a
table name 'Route',
On Wed, Dec 28, 2011 at 4:57 PM, Tom Lane t...@sss.pgh.pa.us wrote:
These grep calls are showing just exactly not enough to prove
anything. I remain unclear as to what state is actually in the
database, or what is being dumped, but I suspect at this point that you
may have multiple sequences
On Wed, Dec 28, 2011 at 4:57 PM, Tom Lane t...@sss.pgh.pa.us wrote:
SELECT pg_catalog.setval('cp_state_id_seq', 52, true);
SELECT pg_catalog.setval('cp_state_id_seq', 1, false);
These grep calls are showing just exactly not enough to prove
anything.
Those grep calls prove my old backups
Alexander Farber alexander.far...@gmail.com wrote:
Hello fellow postgres users,
in my game using PostgreSQL 8.4.9 players can
purchase a VIP (very important person) status:
# \d pref_users;
Table public.pref_users
Column |Type | Modifiers
Hello,
in general my advice would be to stick with native features, therefore
use either Streaming Replication (or alternatively log shipping
replication). You might need some tools to help you manage the cluster,
clients routing and balancing but I suggest you look into this later.
On Thu,
Thank you Andreas - now that one case works ok,
On Thu, Dec 29, 2011 at 7:44 PM, Andreas Kretschmer
akretsch...@spamfence.net wrote:
Try if (not coalesce(has_vip, false)) then ...
but the other case not:
# create or replace function pref_move_week(_from varchar,
_to varchar)
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Thursday, December 29, 2011 3:01 PM
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Verifying a timestamp is null or in the past
Thank you
Might be discussed but not clear for the below query.
In async. streaming replication do I need to run VACUUM ANALYZE on both
master slave as to it is bit to bit replication.
Bec, while querying on master getting below result, but slave's system table is
not updated.
select last_vacuum,
Might be discussed but not clear for the below query.
In async. streaming replication do I need to run VACUUM ANALYZE on both
master slave.
Bec, while querying on master getting below result, but slave's system table is
not updated.
select last_vacuum, last_autovacuum, last_analyze,
22 matches
Mail list logo