Hi all,
I'm trying to compile 9.3.5 from ports on FreeBSD 10.1-release with
dtrace enabled.
It was a long time ago I looked at dtrace + PostgreSQL + FreeBSD (see
[1], [2]), so I'm not updated on how far it got.
The problem I have in compilation is as follows:
gmake[2]: Entering directory
'/mnt/ada
Hi,
I’m trying to use PostgreSQL's full text search for searching names with prefix
matching. I’ve got a materialized view with the tsvector’s in an indexed
column which I’m then searching with prefix matching, as in the sqlfiddle:
http://sqlfiddle.com/#!15/a2389/6 and below.
My problem is th
On Tue, Dec 16, 2014 at 7:49 AM, Luca Ferrari wrote:
>
> Am I missing something?
>
FWIW I tried his a few times, in FreeBSD 9.3 and 10.0 with Pg 9.2 I
believe. I've not ever had it build successfully. I don't know why it is an
option on the port if it doesn't work. I never filed a bug report beca
On 12/15/2014 09:54 PM, harpagornis wrote:
Ah! I figured out the pg_log error about "No pg_hba.conf entry for host
"127.0.0.1", user "SYSTEM", database "postgres", SSL off." That error
occurs when I go into Windows Component Services and restart postgres.
But, after I delete that pg_log file,
Luca Ferrari writes:
> I'm trying to compile 9.3.5 from ports on FreeBSD 10.1-release with
> dtrace enabled.
> It was a long time ago I looked at dtrace + PostgreSQL + FreeBSD (see
> [1], [2]), so I'm not updated on how far it got.
> The problem I have in compilation is as follows:
> dtrace -C -h
On Tue, 16 Dec 2014 14:59:51 +0200
Heikki Rauhala wrote:
Hi Heikki,
There is a typo :
>
> create materialized view name_fulltext as
ERREUR: erreur de syntaxe sur ou près de « materialized »
LIGNE 1 : create materialized view name_fulltext as
You might want to post the results too, next time
Heikki Rauhala writes:
> Should text search prefixes work predicatably as documented in [1] even if
> the lexemes are shorter than the query? How can I get it to work?
I believe what you're seeing can be explained by these observations:
regression=# select to_tsvector('finnish', 'sofia');
to_t
On Mon, Dec 15, 2014 at 7:12 PM, Sameer Kumar
wrote:
>
> On 16 Dec 2014 01:13, "Joseph Kregloh" wrote:
> >
> > Hello,
> >
> > I have a master multi slave streaming replication setup. One master and
> two slaves. I need to do some maintenance on one of the slaves as one of
> the drives died howev
On 12/16/2014 07:29 AM, Ramesh T wrote:
hi,
i need to export a file the database
postgres
pg_dump -U postgres -C -Fp -f c:/backup/db2.dump db_1;
where i can run pg_dump
please send me details
i want to export db_1 to db2
i got an error below
postgres=# pg_dump -U postgres -C -Fp -f c:/backup/
On 12/16/2014 07:52 AM, Ramesh T wrote:
CCing list.
1.
-bash-4.1$ pg_dump -C -Fp -f C:\backup\db_1.dump db_2
how to export and where i can save export file
Per my previous post:
That would depend on where your Postgres server is relative to the c:\
drive.
--
Adrian Klaver
adrian.
> On 12/16/2014 07:52 AM, Ramesh T wrote:
> > 1. -bash-4.1$ pg_dump -C -Fp -f C:\backup\db_1.dump db_2
I doubt that you'll have much success pg_dumping to a Windows path when
running from within a UNIX shell ?
I didn't see the beginning of this thread -- are you running bash under
Windows by w
Right, I want to try connecting by psql, but the postgres documentation and
"psql -- help" do not list the syntax for providing the certificate. I
tried the following, but the error was : "Connection requires a valid
certificate"
$
O.K. I just found the environment variables for SSL, described in Man 31.14.
I will try that.
--
View this message in context:
http://postgresql.nabble.com/SSL-Certificates-in-Windows-7-Postgres-9-3-tp5830749p5830961.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Trying to connect via psql, I looked at the documentation and around the web,
but could not find the right syntax for including all the SSL connection
variables on the psql command line. I tried using the URL-type psql
command, variations of this:
--
harpagornis wrote
> psql dbname=dbname user=my_role sslmode=verify-full sslcert=postgresql.crt
> sslkey=postgresql.key sslrootcert=root.crt
This is a psql command with 6 input arguments/options specified
psql "dbname=dbname [...]" is a psql command with 1 input argument/option
specified which is
On 12/10/2014 01:48 PM, Tomas Vondra wrote:
On 10.12.2014 17:07, Gabriel Sánchez Martínez wrote:
Hi all,
I am running PostgreSQL 9.3.5 on Ubuntu Server 14.04 64 bit with 64 GB
of RAM. When running pg_dump on a specific table, I get the following
error:
pg_dump: Dumping the contents of table
Unless I am missing something, I still do not see where how / where to
specify sslcert, sslkey, root.crt in the psql command. The referenced links
don't much go beyond these input variables [ dbname [ username ] [ host ] [
port ] .
--
View this message in context:
http://postgresql.nabble.com/
harpagornis writes:
> Unless I am missing something, I still do not see where how / where to
> specify sslcert, sslkey, root.crt in the psql command.
You don't. The SSL certificates are stored in files whose names are known
to the psql code. See
http://www.postgresql.org/docs/9.3/static/libpq-s
harpagornis wrote
> @SET PATH="C:\Program Files\PostgreSQL\9.3\bin";%PATH%
> @SET PGDATA=D:\PostgresDat
> @SET PGDATABASE=postgres
> @SET PGUSER=postgres
> @SET PGPORT=5432
> @SET PGSSLCERT=D:\POSTGRESDAT\POSTGRESQL.CRT
> @SET PGSSLKEY=D:\POSTGRESDAT\POSTGRESQL.KEY
> @SET PGSSLROOTCERT=D:\POSTGRESD
On 12/16/2014 08:17 AM, Ramesh T wrote:
C:\Program Files\pgAdmin III\1.14>pg_dump -U postgres -p 5432 -C -f
c:\backup\db_2.dump db_1;
pg_dump: [archiver (db)] connection to database "db_1;"
failed: coul
d not connect to server: Connection refused (0x274D/10061)
Is the server runnin
I understand all of that, about certificates. I only included all of the
pg_env.bat file for completeness. You understand that I am trying to
connect to the database by using just psql?
--
View this message in context:
http://postgresql.nabble.com/SSL-Certificates-in-Windows-7-Postgres-9-3-tp
harpagornis wrote
> I understand all of that, about certificates. I only included all of the
> pg_env.bat file for completeness. You understand that I am trying to
> connect to the database by using just psql?
Yes, and are doing so with non-default locations for pretty much everything.
Given
Yes, I have tested that the connection and it does work without SSL. I have
also verified with openssl that all the certificates have the same CN,
issuer, etc.
I am working in a development environment, hence the seemingly odd file
location. It may not seem that way, but I am narrowing down th
hi,
i need to export a file the database
postgres
pg_dump -U postgres -C -Fp -f c:/backup/db2.dump db_1;
where i can run pg_dump
please send me details
i want to export db_1 to db2
i got an error below
postgres=# pg_dump -U postgres -C -Fp -f c:/backup/db_2.dump
db_1;
ERROR: syntax error at o
C:\Program Files\pgAdmin III\1.14>pg_dump -U postgres -p 5432 -C -f
c:\backup\db_2.dump db_1;
pg_dump: [archiver (db)] connection to database "db_1;"
failed: coul
d not connect to server: Connection refused (0x274D/10061)
Is the server running on host "localhost" (::1) and accepting
To anyone following this thread, I would also like to point out the
following, from Man 31.18.1.
In verify-full mode, the cn (Common Name) attribute of the certificate is
matched against the host name. If the cn attribute starts with an asterisk
(*), it will be treated as a wildcard, and will ma
On 12/16/2014 08:56 PM, harpagornis wrote:
To anyone following this thread, I would also like to point out the
following, from Man 31.18.1.
In verify-full mode, the cn (Common Name) attribute of the certificate is
matched against the host name. If the cn attribute starts with an asterisk
(*), it
Thank you. That resolved it. After revising the certificates, I was able to
connect with psql. I really appreciate all the help.
--
View this message in context:
http://postgresql.nabble.com/SSL-Certificates-in-Windows-7-Postgres-9-3-tp5830749p5831051.html
Sent from the PostgreSQL - general
On 16.12.2014, at 17:09, Vincent Veyron wrote:
> On Tue, 16 Dec 2014 14:59:51 +0200
> Heikki Rauhala wrote:
>
> Hi Heikki,
>
> There is a typo :
>
>> create materialized view name_fulltext as
>
> ERREUR: erreur de syntaxe sur ou près de « materialized »
> LIGNE 1 : create materialized view
On Tue, Dec 16, 2014 at 4:06 PM, Tom Lane wrote:
> If you want to push on this I think you'll need to find a BSD dtrace
> expert. You shouldn't need to show him/her much except the above
> dtrace invocation and the probes.d file.
>
I've filled a bug report and I'll report back here if I get any
30 matches
Mail list logo
