Hi,
pgpool-II also offers native replication maintaining several real time backups.
The docu also states: "There is no guarantee that any data provided using a
context-dependent mechanism (e.g. random number, transaction ID, OID, SERIAL,
sequence), will be replicated correctly on multiple backe
I'm loading data into tables with the 'insert' statement. There are many
rows containing values and each is bracketed by parentheses except for the
last row. That's terminated with a semicolon, but psql reports an error
there:
psql:organizations.sql:1926: ERROR: syntax error at or near ";"
LINE
On 10/29/20 9:43 AM, Rich Shepard wrote:
I'm loading data into tables with the 'insert' statement. There are many
rows containing values and each is bracketed by parentheses except for the
last row. That's terminated with a semicolon, but psql reports an error
there:
psql:organizations.sql:19
Rich Shepard writes:
> I'm loading data into tables with the 'insert' statement. There are many
> rows containing values and each is bracketed by parentheses except for the
> last row. That's terminated with a semicolon, but psql reports an error
> there:
> psql:organizations.sql:1926: ERROR: sy
On Thu, 29 Oct 2020, Rob Sargent wrote:
Can we see the last two line of the file (1924, 1925)?
Rob,
(2697,'Port of
Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
(2698,'Port of
Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
Each line is
Hi Rich,
> On 29. Oct, 2020, at 16:58, Rich Shepard wrote:
>
> On Thu, 29 Oct 2020, Rob Sargent wrote:
>
>> Can we see the last two line of the file (1924, 1925)?
>
> Rob,
>
> (2697,'Port of
> Newport','http://www.portofnewport.com',null,'Port','Opportunity',null),
> (2698,'Port of
> Portla
On Thu, 29 Oct 2020, Paul Förster wrote:
(2698,'Port of
Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
the last line has a closing parenthesis missing.
Paul,
I see a closing parenthesis immediately in front of the semi-colon and emacs
shows it matches the opening
On 10/29/20 9:08 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Paul Förster wrote:
(2698,'Port of
Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
the last line has a closing parenthesis missing.
Paul,
I see a closing parenthesis immediately in front of the semi-c
Hi Rich,
> On 29. Oct, 2020, at 17:08, Rich Shepard wrote:
>
> On Thu, 29 Oct 2020, Paul Förster wrote:
>
>>> (2698,'Port of
>>> Portland','http://www.portofportland.com',null,'Port','Opportunity',null);
>> the last line has a closing parenthesis missing.
>
> Paul,
>
> I see a closing parent
On Thu, Oct 29, 2020 at 9:16 AM Paul Förster
wrote:
> But I guess that Emacs shows the matching closing bracket at the beginning
> of the line, which matches that single tuple. But you also need a closing
> bracket for the set of tuples like this:
>
> insert ...
> (
> (v1, v2, v3),
> (v4,
Hi David,
> On 29. Oct, 2020, at 17:21, David G. Johnston
> wrote:
>
> On Thu, Oct 29, 2020 at 9:16 AM Paul Förster wrote:
> But I guess that Emacs shows the matching closing bracket at the beginning of
> the line, which matches that single tuple. But you also need a closing
> bracket for th
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Pretty sure the thinking is that the opening parenthesis is further upstream,
say around VALUES?
Well, duh! Of course. I forgot to enclose all value rows. Mea culpa!
Thanks,
Rich
On Thu, 29 Oct 2020, Paul Förster wrote:
insert ...
(
(v1, v2, v3),
(v4, v5, v6),
(v7, v8, v9)<= this is the bracket pair that Emacs shows as matching.
); <= this is the missing bracket.
Paul/Adrian/Tom:
First thing I did was look at the postgres 12 manual. On page 155 I see:
On Thu, 29 Oct 2020, David G. Johnston wrote:
That said seeing the first few rows, in addition to the last few, would
help.
David,
insert into organizations (org_nbr,org_name,org_url,org_email,industry,status,comment) values
(1,'Tidewater Contractors Inc',null,null,'Mining','Opportunity','GE
On Thu, Oct 29, 2020 at 9:37 AM Rich Shepard
wrote:
> On Thu, 29 Oct 2020, David G. Johnston wrote:
>
> > That said seeing the first few rows, in addition to the last few, would
> > help.
>
> David,
>
> insert into organizations
> (org_nbr,org_name,org_url,org_email,industry,status,comment) value
On 10/29/20 9:35 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Paul Förster wrote:
insert ...
(
(v1, v2, v3),
(v4, v5, v6),
(v7, v8, v9) <= this is the bracket pair that Emacs shows as
matching.
); <= this is the missing bracket.
Paul/Adrian/Tom:
First thing I did was look a
On Thu, 29 Oct 2020, David G. Johnston wrote:
As your general syntax seems correct I would suspect an issue in the data
values - like having a single quote in an organization name that isn't
properly escaped (doubled). I'd first make sure insert one record works
then begin bisecting your values,
On Thu, 29 Oct 2020, Adrian Klaver wrote:
INSERT INTO products (product_no, name, price) VALUES
(
(1, 'Cheese', 9.99),
(2, 'Bread', 1.99),
(3, 'Milk', 2.99)
);
then you should have gotten a different error. Something like:
ERROR: column "product_no" is of type integer but expressi
On 10/29/20 9:59 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
INSERT INTO products (product_no, name, price) VALUES
(
(1, 'Cheese', 9.99),
(2, 'Bread', 1.99),
(3, 'Milk', 2.99)
);
then you should have gotten a different error. Something like:
ERROR: column "p
On Thu, 29 Oct 2020, Rich Shepard wrote:
psql:organizations.sql:1926: ERROR: syntax error at or near ";"
LINE 1925: ...m',null,'Port','Opportunity',null);
^
I'm not seeing why that's an error. All previous rows terminate with a comma
and I don't
Rich Shepard writes:
> Found the problem in line 26 of 1925 rows: a non-null column had 'null'
> entered rather than one of the allowed values. That row was in the original
> database and I've no idea when I might have changed that.
> Why postgres didn't highlight that until I had only a 50-line
On Thu, Oct 29, 2020, 10:39 Rich Shepard wrote:
> On Thu, 29 Oct 2020, Rich Shepard wrote:
>
> > psql:organizations.sql:1926: ERROR: syntax error at or near ";"
> > LINE 1925: ...m',null,'Port','Opportunity',null);
> ^
> > I'm not seeing why that'
On 10/29/20 10:39 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Rich Shepard wrote:
psql:organizations.sql:1926: ERROR: syntax error at or near ";"
LINE 1925: ...m',null,'Port','Opportunity',null);
^
I'm not seeing why that's an error. All previ
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is orgs-1.sql just the INSERT?
Yes.
How is that file being fed to psql?
$ psql -d bustrac -f orgs-1.sql
Rich
On 10/29/20 10:52 AM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is orgs-1.sql just the INSERT?
Yes.
Is it just the 50 line version?
If it is, what happens if you go back to original 1925 line version and
correct the NULL issue in the line 26 and run it again?
How
hi,
My problem is, that I am always asked for password when trying to
interact with the database or access it, although the authentication
is set to trust for all users and databases.
Please help.
Regards,
Atul
On 10/29/20 10:59 AM, Atul Kumar wrote:
hi,
My problem is, that I am always asked for password when trying to
interact with the database or access it, although the authentication
is set to trust for all users and databases.
What is the connection command you are using?
Did you reload the serv
Please make sure you are not using -w option while connecting through psql.
On Thu, 29 Oct 2020, 11:30 pm Atul Kumar, wrote:
> hi,
>
> My problem is, that I am always asked for password when trying to
> interact with the database or access it, although the authentication
> is set to trust for al
hi,
I am trying to configure streaming replication on windows server.
i have postgres version 10
after successful installation of postgres, I create a archive
directory "C:\Program Files\PostgreSQL\10\archive_files" and here in
archive_flies, I need to copy the wal files.
in postgresql conf fi
Am 29.10.20 um 20:12 schrieb Atul Kumar:
hi,
I am trying to configure streaming replication on windows server.
i have postgres version 10
after successful installation of postgres, I create a archive
directory "C:\Program Files\PostgreSQL\10\archive_files" and here in
archive_flies, I need
hi,
Still it is not getting copied in the archive directory
show archive_command
"copy "%p" "C:\Program Files\PostgreSQL\10\archive_files\%f""
in postgresql.conf
archive_command = 'copy "%p" "C:\\Program
Files\\PostgreSQL\\10\\archive_files\\%f"'
and when I restarted the postgres service using
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is it just the 50 line version?
Adrian,
Nope.
If it is, what happens if you go back to original 1925 line version and
correct the NULL issue in the line 26 and run it again?
I'm finding typos and column tranposition errors that I had not spotted w
On 10/29/20 2:07 PM, Rich Shepard wrote:
On Thu, 29 Oct 2020, Adrian Klaver wrote:
Is it just the 50 line version?
Adrian,
Nope.
If it is, what happens if you go back to original 1925 line version
and correct the NULL issue in the line 26 and run it again?
I'm finding typos and column
On Thu, 29 Oct 2020, Rob Sargent wrote:
Would it be rude to suggest that you re-visit how that file was made?
Seems you'll be in the same boat "next time".
Rob,
Part of the files was exported from the old version of the database. New
rows were from different text files, each with a different
I would try..
Read the server log
Try copying to another simpler path like C:\wal_archives
Maybe blankspaces give problems
Have you forgotten to configure any other parameter like max_wal_senders?
I hope some of this hemos you
Loles
El jue., 29 oct. 2020 20:36, Atul Kumar escribió:
> hi,
>
35 matches
Mail list logo
