I call initdb with such params
*/opt/PostgreSQL/9.1/bin/initdb -D /projects/data_dir/data -E UTF-8 -U u*ser
after that create pg_log dir when I would create log (but why I must do this
step?)
change hba file and start database server with this command
/*opt/PostgreSQL/9.1/bin/pg_ctl start -w -D /
sorry, my mistake when I connect to user I set login to "postgres"
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/call-initdb-as-regular-user-tp4712980p4714912.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing
Hi!
I try create master for replication and in his config I set
synchronous_standby_names = '*'
so I can connect with other slave's (name of this slave I don't know at this
moment)
But if I try execute some commands (I hung on 'create database') my program
hang and after some time I see
in process
On Fri, Aug 19, 2011 at 7:06 PM, alexondi wrote:
> Hi!
> I try create master for replication and in his config I set
> synchronous_standby_names = '*'
> so I can connect with other slave's (name of this slave I don't know at this
> moment)
> But if I try execute some commands (I hung on 'create da
but if I don't have any slave at this time why my command hang?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715224.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing
Hell l,
I am trying to debug a query that gives an error. The error in the
application server log is
" ERROR: operator does not exist: timestamp without time zone = character
varying
Hint: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
Po
On Fri, Aug 19, 2011 at 8:04 PM, alexondi wrote:
> but if I don't have any slave at this time why my command hang?
Because there is no standby at that time ;)
If synchronous replication is enabled but there is no standby connecting
to the master, a write transaction waits until at least one sync
so can I somehow disable|enable synchronous replication at runtime (not only
for session but for the server)?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/synchronous-standby-names-with-tp4715117p4715296.html
Sent from the PostgreSQL - general mailing list archive at N
On Fri, Aug 19, 2011 at 8:39 PM, alexondi wrote:
> so can I somehow disable|enable synchronous replication at runtime (not only
> for session but for the server)?
Yes.
To disable;
Empty synchronous_standby_names, or set synchronous_commit to "local" or "off".
To enable;
Set synchronous_standby_
Hi,
Is there maybe GIST support patch for UUID datatype?
I do not it it concretly just for UUID column... it is more because of I
need it in EXCLUDE constraint...
CREATE TABLE test_exclude
{
id serial NOT NULL,
guid uuid NOT NULL,
valid_period period NOT NULL,
CONSTRAINT "test_excludepk" PRIMARY
I think if master has not slave's at this time then server must use "local"
mode. But if he has >=1 slave then he must wait until slave accept
transaction. And "synchronous_standby_names" select behaviour about how
master shoud select which slave must be synchronous or not. And when this
GUC is '*'
I think
set synchronous_commit to "off"
Disable synchronous commit only for this session (connect) not for postgres
instance, right?
Maybe I must chnage configuration and call "pg_ctl reload"? to change
deafult behaviour for postgres instance?
2011/8/19 Fujii Masao
> On Fri, Aug 19, 2011 at 8:39
Hi All,
how to insert mysql (datetime interval) data to postgrres interval datatype.
mysql
| test_interval | datetime | YES | | 1970-01-02 00:00:00 |
|
psql
test_interval | interval |
any solution for this?
thanks
Deepak
On Fri, Aug 19, 2011 at 12:04 PM, alexondi wrote:
> but if I don't have any slave at this time why my command hang?
Setting synchronous_standby_names means "wait until my standby replies".
If you don't have a standby, then you just made a request to wait for
a long time.
Suggest different appr
Yes, sure.
I have already used it. You have to create database connections to both of
your databases. Then create a job to sync data per table as per your needs.
It should not be too hard. Once you job is created then test it for any
errors. If required you have to use data transformations. Once yo
Just use postgresql wiki, postgresql documentation, and few sites who
compare postgresql and oracle.
Both are good database systems, postgresql is open source and free, runs on
most platforms, easy to install and manage than oracle, supports very large
database.
Chaitany Kulkarni
On Thu, Aug 18,
On 8/19/2011 7:50 AM, DM wrote:
Hi All,
how to insert mysql (datetime interval) data to postgrres interval datatype.
mysql
| test_interval | datetime | YES | | 1970-01-02 00:00:00 |
|
psql
test_interval | interval |
any solution for this?
thank
On 8/19/2011 6:19 AM, Jayadevan M wrote:
Hell l,
I am trying to debug a query that gives an error. The error in the
application server log is
" ERROR: operator does not exist: timestamp without time zone =
character varying
Hint: No operator matches the given name and argument type(s). You might
On Friday, August 19, 2011 6:55:39 am Andy Colson wrote:
> > As of now, I am trying with logging level set to debug5 in
> > postgresql.conf for all logging options. But what is the 'correct'
> > approach?
> >
> > Regards,
> > Jayadevan
>
> Not sure what the exact setting is, try:
>
> log_stateme
Jayadevan M writes:
> I am trying to debug a query that gives an error. The error in the
> application server log is
> " ERROR: operator does not exist: timestamp without time zone = character
> varying
> It looks like the error is for the condition ( CUSINDINF.MEMDOB ) = ($4) ,
> memdob bein
On 8/19/2011 9:01 AM, Adrian Klaver wrote:
On Friday, August 19, 2011 6:55:39 am Andy Colson wrote:
As of now, I am trying with logging level set to debug5 in
postgresql.conf for all logging options. But what is the 'correct'
approach?
Regards,
Jayadevan
Not sure what the exact setting is, tr
On Thursday, August 18, 2011 3:25:59 pm Dmitry Koterov wrote:
> Mmm, --disable-triggers is not surely enough - we also have RULEs and (much
> worse) INDEXes.
>
> If we create all indices and then restore all data, it is MUCH SLOWER than
> restore the data first and then - create all indices.
> So
Is there a way to get the linux idsid of a user, even for a remote network
connection?
If not, is there a way to capture this somehow when the original connection is
made and maybe stuff it in a temp table or something using whatever means (a
trigger-like mechanism? ) ? Is there a script/func
On Thursday 18 August 2011 13:08:18 Jerry Sievers wrote:
> Vincent de Phily writes:
> > The thing is, I know there is no violation by existing data, because of
> > the existing fkey. So locking and scaning the table to add the
> > "duplicate" fkey is>
> > not necessary. In a sense, I'm looking fo
On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
> Is there a way to get the linux idsid of a user, even for a remote network
> connection?
>
> I could write a pg-perlu to get this, but I suspect it won't give me the
> original user when there's a remote connect.
>
> Thanks for any suggestion
I'm tearing my hair out trying to understand time zones.
I want to use date_trunc to find the start and end of last day, week, month
at a remote site.
I looked at the date_trunc docs and they say
function date_trunc(text, timestamp)
Return Type timestamp
Description Tr
Vincent de Phily writes:
> On Thursday 18 August 2011 13:08:18 Jerry Sievers wrote:
>> Your 2 catalog fields of interest are;
>> pg_constraint.(confupdtype|confdeltype)
>>
>> Changing those for the relevant FKs should satisfy your needs. I am
>> not aware of those field values being duplicated a
On Fri, Aug 19, 2011 at 8:40 AM, Alan Hodgson wrote:
> On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
>> Is there a way to get the linux idsid of a user, even for a remote network
>> connection?
>>
>> I could write a pg-perlu to get this, but I suspect it won't give me the
>> original user w
Alan Hodgson writes:
> On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
>> Is there a way to get the linux idsid of a user, even for a remote network
>> connection?
> There's an identd protocol for this. It's not commonly used anymore, and when
> present tends to deliberately obscure the resu
dexdyne writes:
> So it looks as if date_trunc is taking either type and returning a value of
> the same type.
Yes, as \df would have told you.
> A perfectly reasonable thing to do - but does that correspond with the
> documentation?
Could be a bit more specific, perhaps.
Not too worried about nefarious id faking in this environment.
How does one use "identd" in an unobscured way?
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Friday, August 19, 2011 11:55 AM
To: Alan Ho
On Friday 19 August 2011 11:52:50 Tom Lane wrote:
> Vincent de Phily writes:
> > Thanks for your answer. Experimenting a bit, those columns seem to have
> > only a cosmetic impact, meaning that "\d" will show the schema you
> > expect, but the behaviour remains unchanged (even after restarting
> >
"Gauthier, Dave" writes:
> Not too worried about nefarious id faking in this environment.
> How does one use "identd" in an unobscured way?
There's a command-line switch for the identd daemon, on most machines,
that tells it whether to send hashed or plaintext responses.
Vincent de Phily writes:
> On Friday 19 August 2011 11:52:50 Tom Lane wrote:
>> IIRC, there are fields of pg_constraint that are copied into the
>> pg_trigger rows for the supporting triggers, so as to save one catalog
>> lookup at run time. If you diddle one manually, you'd better diddle
>> both
On Friday 19 August 2011 12:55:01 Tom Lane wrote:
> Vincent de Phily writes:
> > On Friday 19 August 2011 11:52:50 Tom Lane wrote:
> >> IIRC, there are fields of pg_constraint that are copied into the
> >> pg_trigger rows for the supporting triggers, so as to save one catalog
> >> lookup at run ti
In early 2009 I asked whether there was a hack to allow PostgreSQL's
listen/notify commands via ODBC, some while later I believe that
somebody sent me example code encoded as base64 which erroneously got
deleted as spam.
Google suggests that several other people have asked about this over the
Short description:
* Need: migration of database, with roles relevant to it.
* "From" server: pg 8.1; no superuser access.
* "To" server: pg 8.4; full access.
* Database in question: depends on few roles, mainly group roles used
to set permission; there are other roles (login roles) which are
membe
On 19 Aug 2011, at 14:50, DM wrote:
> Hi All,
>
> how to insert mysql (datetime interval) data to postgrres interval datatype.
>
> mysql
> | test_interval | datetime | YES | | 1970-01-02 00:00:00 |
> |
>
> psql
> test_interval | interval |
>
>
> an
I apologize for my english and... also for the explanation perhaps not
very clear.
I have some doubt regarding the planner choice for my query, usually it
does a very good job and I would prefer to leave free the planner but
with this query I have some doubt:
I use tree tables, cartellino with
On Fri, Aug 19, 2011 at 1:05 PM, Edoardo Panfili wrote:
> [1] Plan for the firts query
> ---
> Sort (cost=20.45..20.46 rows=1 width=931) (actual tim
Il 19/08/11 22:15, Scott Marlowe ha scritto:
On Fri, Aug 19, 2011 at 1:05 PM, Edoardo Panfili wrote:
[1] Plan for the firts query
---
Sort (cost
Dmitry Koterov writes:
> Is there any way (or hack) to dump the whole database, but to exclude the
> DATA from a table within this dump? (DDL of the table should not be
> excluded: after restoring the data the excluded table should look "empty".)
The pg_staging tool allows you to do that quite ea
array_agg says it can take any type of arg, but this seems not to work
when the arg in an integer array.
create temp table x(name text, val integer[]);
insert into x values('a',array[1,2,3]);
insert into x values('b',array[3,4,5]);
select * from x;
select max(val), min(val) from x;
select array_ag
On Fri, Aug 19, 2011 at 4:22 PM, TJ O'Donnell wrote:
> array_agg says it can take any type of arg, but this seems not to work
> when the arg in an integer array.
>
> create temp table x(name text, val integer[]);
> insert into x values('a',array[1,2,3]);
> insert into x values('b',array[3,4,5]);
>
On Fri, Aug 19, 2011 at 2:37 PM, Edoardo Panfili wrote:
>
> work_mem = 1MB
> random_page_cost = 4
>
> I am using an SSD but the production system uses a standard hard disk.
>
> I did a try also with
> set default_statistics_target=1;
> vacuum analyze cartellino;
> vacuum analyze specie; -- t
Array_agg is not implemented for arrays.
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Edoardo Panfili writes:
> [ poor plan for a Postgis query with ]
> Postgres 8.4.8 with postgis 1.5.3
I think that most of the issue here is poor selectivity estimation for
the Postgis operations, particularly &&. I suggest that you should ask
about this on the postgis mailing lists. They might
Il 20/08/11 04:28, Tom Lane ha scritto:
Edoardo Panfili writes:
[ poor plan for a Postgis query with ]
Postgres 8.4.8 with postgis 1.5.3
I think that most of the issue here is poor selectivity estimation for
the Postgis operations, particularly&&. I suggest that you should ask
about this on
48 matches
Mail list logo
