Hi all,
We have a table in a database DB1 with name Test. We imported this database
from another machine.
When I fire insert statement it is going in the hang state.
Then I created another table with same structure and with same data within it
as in table Test.
Then I fired the insert statemen
hi ,
I am trying to attach a postgres process to gdb, Since I am using only 1
client , I am using the script give by Tom Lane posted in the mailing list.
http://www.postgresql.org/message-id/bd6a35510707221030p694cd515kfeb529078557b...@mail.gmail.com
I started running the client by following co
Actually problem is in customer site in their production environment.
They have their database MDB. In that db they have insert issue with one table.
They shared the data folder with us.
We past the same data folder in our local DB which has the same name MDB and
reproduced the issue.
After r
Hello my pg_hab.conf has this entry:
hostall all 127.0.0.1/32md5
When I try to use PHP to connect to the Database I get
"postgres password authentication failed for user ..."
The PHP-code looks like
global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql,
On Wed, Jul 9, 2014 at 11:34 AM, M Tarkeshwar Rao
wrote:
>
> We analysed one more thing when we removed the unique index from the table it
> is working fine.
> Is there any issue in indexing?
>
> Is there any option to repair the table or its indexing?
REINDEX is useful for indexes.
>From the s
On Wed, 09 Jul 2014 13:04:19 +0200 basti wrote:
> Hello my pg_hab.conf has this entry:
>
> hostall all 127.0.0.1/32md5
>
> When I try to use PHP to connect to the Database I get
>
> "postgres password authentication failed for user ..."
>
> The PHP-code
There are indices:
table:measurement_events"measurement_events_pkey" PRIMARY KEY, btree
(measurement_source_id, measurement_time)
table:measurement_sources"measurement_sources_pkey" PRIMARY KEY, btree
(measurement_source_id)
-Spiros
On 8 July 2014 18:10, Andy Colson wrote:
> On 7/8/201
On Wed, Jul 9, 2014 at 12:45 PM, Ramesh T
wrote:
> HI,
> I have a problem when i take backup using pg_basebackup and
> pg_start_backup('base');
> following ,
>
What is the problem? You didn't write it. Just some outputs and config, but
you never mentioned what is the problem itself.
Hi:
On Wed, Jul 9, 2014 at 1:04 PM, basti wrote:
> Hello my pg_hab.conf has this entry:
> hostall all 127.0.0.1/32md5
> global $dbhost, $dbuser, $dbpass, $dbname, $use_pgsql, $dbconn;
...
> $connect = "host=$dbhost user=$dbuser password=$dbpass
Yes, there is the same problem.
postgres logs also:
"Connection matched pg_hba.conf line 93
„hostall all 127.0.0.1/32md5“"
Am 09.07.2014 13:14, schrieb Bill Moran:
> On Wed, 09 Jul 2014 13:04:19 +0200 basti wrote:
>
>> Hello my pg_hab.conf has this entry:
Here is the output of the echo.
host=127.0.0.1 user=mydns password=mypass sslmode=allow dbname=mydns
I have also try host=localhost and sslmode=require
Am 09.07.2014 13:47, schrieb Francisco Olarte:
> Hi:
>
> On Wed, Jul 9, 2014 at 1:04 PM, basti wrote:
>> Hello my pg_hab.conf has this entry:
Hi Greg,
Sending few discussions with one of the postgres person. You will understand
what is the problem.
Regards
Tarkeshwar
Can this be of help [1]?
[1]
http://www.postgresql.org/docs/9.2/static/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY
Regards,
Niklas
__
Hi,
First - do not take the messages off list. Someone else might be able to
help you if you'll mail to the list, I'm not always there, and others might
have better ideas.
On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T
wrote:
> i rune problem is when i run the pg_stop_backup() its return error in
On 07/09/2014 03:34 AM, M Tarkeshwar Rao wrote:
Please do not top post.
Actually problem is in customer site in their production environment.
They have their database MDB. In that db they have insert issue with one table.
They shared the data folder with us.
So you are just copying a direct
On 07/09/2014 04:04 AM, basti wrote:
Hello my pg_hab.conf has this entry:
hostall all 127.0.0.1/32md5
Is that the only entry?
If not remember first matching entry wins, so is there another line
above this?
When I try to use PHP to connect to the Da
There are other entrys in pg_hab.conf and yes the passwd is correct.
(psql -p ... -h ... from command line runs well).
I don't know whats wrong there
hostmydns mydnslocalhost trust
works well and
#hostall all 0.0.0.0 0.0.0.0
On Wed, 2014-07-09 at 14:01 +0200, basti wrote:
> Yes, there is the same problem.
> postgres logs also:
>
> "Connection matched pg_hba.conf line 93
> „hostall all 127.0.0.1/32md5“"
>
> Am 09.07.2014 13:14, schrieb Bill Moran:
> > On Wed, 09 Jul 2014 13:0
On 07/09/2014 06:10 AM, basti wrote:
There are other entrys in pg_hab.conf and yes the passwd is correct.
So what are the other entries and where are they relative to the line
that you think is causing the problem?
(psql -p ... -h ... from command line runs well).
In your first post you s
On 07/09/2014 06:19 AM, rob stone wrote:
You need to use "sslmode=require".
Are you encrypting the password? If not, alter the pg_hba.conf file to
"trust" instead of md5. If it's all running on localhost it's no big
deal.
AFAIK PHP, in the connect function, takes care of encrypting the
Ravi Kiran writes:
> I am trying to attach a postgres process to gdb, Since I am using only 1
> client , I am using the script give by Tom Lane posted in the mailing list.
> http://www.postgresql.org/message-id/bd6a35510707221030p694cd515kfeb529078557b...@mail.gmail.com
You realize that's from 20
Is there a simple md5 hash?
I also try to hash my passwd via md5.
There is sill the same error.
Am 09.07.2014 15:19, schrieb rob stone:
> Are you encrypting the password? If not, alter the pg_hba.conf file to
> "trust" instead of md5. If it's all running on localhost it's no big
> deal.
--
Sent
On 9 July 2014 15:10, basti wrote:
> There are other entrys in pg_hab.conf and yes the passwd is correct.
> (psql -p ... -h ... from command line runs well).
I do hope you're looking in a file named pg_hba.conf and not
pg_hab.conf? The latter is unknown to PG, you should throw that away
if it's t
Hi,
On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T
> wrote:
>
>> i rune problem is when i run the pg_stop_backup() its return error in
>> this way
>>
>> postgres=# select pg_stop_backup();
>>
>>
>> *NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments
>> to be ar*
>> *chived*
>> *
On Wed, Jul 9, 2014 at 3:28 PM, Ramesh T
wrote:
> Yes,not an error it is a warning and archive is working.
>
How can you say that archive is working when in logs you have?
> 2014-07-09 18:53:33 IST LOG: archive command failed with exit code 1
> 2014-07-09 18:53:33 IST DETAIL: The fail
On Wed, Jul 9, 2014 at 5:04 AM, basti wrote:
> Hello my pg_hab.conf has this entry:
>
> hostall all 127.0.0.1/32md5
>
> When I try to use PHP to connect to the Database I get
>
> "postgres password authentication failed for user ..."
>
> The PHP-code looks l
Hello,
I'm tempted to download the Postgresql 9.4 beta for Windows and can not,
the download link http://www.postgresql.org/download only redirects to
EnterpriseDB which is available only to versions page:
http://www.enterprisedb.com/products-services-training/pgdownload #
windows
I would l
On Wed, Jul 9, 2014 at 1:25 PM, M Tarkeshwar Rao
wrote:
>
> I am sharing the table structure. When we removed the unique index it is
> working fine.
> And when created normal index(not unique) it is working fine.
>
> After removing unique index we tried to recreate it but it is giving
> followin
On 07/09/2014 06:56 AM, Edson F. Lidorio wrote:
Hello,
I'm tempted to download the Postgresql 9.4 beta for Windows and can not,
the download link http://www.postgresql.org/download only redirects to
EnterpriseDB which is available only to versions page:
http://www.enterprisedb.com/products-servi
Hello, I can't seem to find the allowed values for OIDs.
result = PQprepare(parrentcon, insertstmt, insert, 2, /*FIXME*/);
Both arguments are to be of type char * in C and of type varchar(255) in sql.
I looked in the docs but I can't seem to find where OIDs are enumerated, please point me in the
On 7/9/2014 2:41 PM, frank ernest wrote:
Hello, I can't seem to find the allowed values for OIDs.
result = PQprepare(parrentcon, insertstmt, insert, 2, /*FIXME*/);
Both arguments are to be of type char * in C and of type varchar(255) in
sql.
I looked in the docs but I can't seem to find where OID
Hi,
Are there any publicly available synonym/thesaurus dictionaries for FTS?
Thank you.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray...@gmail.com
--
Sent via pgsql-general mail
HI,
I have a problem when i take backup using pg_basebackup and
pg_start_backup('base');
following ,
1)
select pg_start_backup('base');
pg_start_backup
0/1628
2)
postgres=# select pg_stop_backup();
NOTICE: pg_stop_backup cleanup done, waiting for required WAL
I don't know whats wrong there
hostmydns mydnslocalhost trust
works well and
#hostall all 0.0.0.0 0.0.0.0 md5
did not work.
I use Postgres 9.3.4-1.pgdg70+1.
Am 09.07.2014 14:04, schrieb basti:
> Here is the output of
hi,
Yes,not an error it is a warning and archive is working.
when i archivelog is on in postgresql.conf .
when try to run below statement its return warning and HINT: Check that
your archive_command is executing properly
like below ..
postgres=# select pg_stop_backup();
it is going on
On Wed, Jul 9, 2014 at 10:54 PM, hubert depesz lubaczewski wrote:
> I have 0 knowledge about windows, but I would guess you need to use \\ and
> not \ in the path. Also - does the destination path exist?
>
Confirmed.
--
Michael
On Wed, Jul 9, 2014 at 6:37 AM, basti wrote:
> I don't know whats wrong there
> hostmydns mydnslocalhost trust
> works well and
>
> #hostall all 0.0.0.0 0.0.0.0 md5
> did not work.
>
> I use Postgres 9.3.4-1.pgdg70+1.
>
36 matches
Mail list logo
